Thread: Data Transfer
View Single Post
  #2 (permalink)  
Old June 4th, 2003, 11:01 AM
Jeff Mason Jeff Mason is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Why is DTS not an option? It's probably the best way to do what you want.

Without a schema you could use SELECT INTO statements to create the output tables, whch may or may not set them up correctly, since datatypes of columns in the new table are inferred.

BACKUP/RESTORE might work for you to transfer the entire database.

You can use BCP to transfer data to a file, then from a file to another database, but a schema is ultimately needed.

A schema is ultimately needed anyway, as you'll need indexes, unique and DRI constraints, etc. ...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
Reply With Quote