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
"AG" <ajayz90 (AT) hotmail (DOT) com> wrote
Quote:
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 |