sql server dts: DTS LARGE TABLES ACOSS THE INTERNET -- sql server dts

DTS LARGE TABLES ACOSS THE INTERNET

AG
8/26/2005 8:57:03 AM

sql server dts:

I have to move tables of aproxximately 15 million and 1 million
records, would either replication or DTS able to do this for me?
What would be the best practise to move this amount of data across the
internet using dts/replication?

Thanks in anticipation.

Ajay

Re: DTS LARGE TABLES ACOSS THE INTERNET

Allan Mitchell
8/27/2005 8:15:28 AM

Sure you can move that amount of rows over the internet using either method.
Is this a one time deal or do you do it every day/hour/minute?

What does this move constitute? Is it a database in entirety or is it a few
tables?

You may get good mileage out of exporting locally to text file | Zipping |
FTP | Unzip | BULK INSERT.

Allan

[quoted text, click to view]