sql server dts: I'm converting a large amount of data for a customer. I'm building SQL
Server tables. I want to burn the result onto CDs and send it to my
customer for them to load on their SQL Server. The operation is time
sensitive since their system is shut down for the duration of the
conversion.

My conversion database and the customer's production database have
around 500 tables, but only 20 are involved in the move, but some of the
tables to move have a couple million rows, so efficiency is important.

In the past we've used Backup on the whole database, had the customer
restore it and then copy over table by table. But that required sending
lots of tables we didn't want, or copying tables around which took time.
Also we found that copy under DTS sometimes locked up for no apparent
reason after almost finishing.

What's the most fool-proof and efficient way to move tables around?

Thanks in advance,

Hi Kevin,

Thank you for using the newsgroup and it is my pleasure to help you with
you issue.

As the question of most fool-proof way ( never say most, ^_^) , what I
would commend is using the BCP, please refer to the 'BCP utility' part in
the SQL Server Books Online. You could just import the table in to a file
and then in you customer's side delete the old record and just import from
this file.

If you want to use the GUI, I would say that may be you could create a temp
database and import the tables that need conversion into the temp database,
then detach the database then re-attach the database into another temp
database on the client SQL Server and then import the data from the temp
database into the destination.

Hope this helps and if you still have questions, please feel free to post
message here and I am glad to help.

Thanks.

Sincerely Yours

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

you can use for xml clause and burn the xml file on a CD.
at the receiving end read from the XML file.
hope this helps you

best regards
Chandra A

[quoted text, click to view]