May 3, 2005 at 10:48 am
I need to move data from an old database to another development database containing similiar/same data but now spread across different tables. Could I use DTS to move the data across if the tables are now different in structure? Or would I have to create custom scripts to accomplish this task? Would it be easier and less time-consuming to use DTS or custom scripts? Any feedback would be greatly appreciated.
May 3, 2005 at 12:59 pm
You can use Import/Export and tell it which columns to copy to different table(s)
Good Hunting!
AJ Ahrens
webmaster@kritter.net
May 3, 2005 at 10:48 pm
as per AJ Ahrens you can but primary key must is there
Ajay Sharma
May 4, 2005 at 5:27 am
You could use DTS and specify "SQL Query" in the Transform Data Task. Then just write the query of the columns you want the data from.
Since the structure of the tables are different, you'll need to use the import/export or DTS. If you'll be doing this many times, you may want to use DTS and just save the package for later use.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply