March 30, 2004 at 11:33 am
Hello All,
Haven't been doing DTS with structure in SQL 7.0 for some time.
When I export/import Table in SQL 7.0 does DTS transfers Data only (that is why called Data Tr.Services)
or the structure as well.
If I need to move structure as well (indexes, ,constraints...) what is the best approach to accompish that.
Apply Index scripts before or after the data was transferred.
Is SQL 2000 has the same behavior for transfering the Data.
What are other ways to copy a SINGLE object with structure ( except backup/restore; detach/attach)
TIA
March 30, 2004 at 2:35 pm
You can use DTS to either transfer data to an existing table or create an identical table then transfer data. It's your choice.
If you want to transfer table schema and related objects (indexes, contraints, etc.), you can either script them out from your source database and run the scripts on your destination or use the the DTS 'Transfer SQL Server Objects' task. If you use scripts, create the indexes after loading data, as your loads will run faster.
SQL 2000 DTS offers more tasks and more flexibility, but is basically the same as 7.0.
I would use DTS to transfer a single object between servers because it's easier and more precise than backup/restore or detach/attach which move an entire database.
Greg
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply