data transfer | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

data transfer

I need to transfer data from one database to another on sql server 2000 on the same server. There are about 100 tables to copy in total. Approx. 10 tables have a slightly different schema. What are some ways to transfer this data?
None other than using DTS you can accomplish the task and even if the users are required to transfer then use COPY DATABASE WIZARD. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
what about table schema differences?
In DTS those will be copied accross from source database to destination database when you choose ‘Transfer objects and data between SQL Server databases’. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
I don’t want the schema affected between source and destination.
Then on the next screen of DTS wizard untick ‘Create destination objects (tables,views, sps etc) and select only ‘Copy data’ and as you wish to replace or append the data. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Ignore the reply to use COPY Database wizard in this regard, if only data has to be copied. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
if a destination table had an extra column then no data will be copied for that table. this is the problem.
]]>