There a lot of things you should consider
Can you connect from source database to the target database directly?
Or other way around?
If you can't connect you might need to export entire table into a text file transfer it across
Do you have enough disk space on the target server?
Copy 100k rows, check you disk space, check how long did it take.
It will give you the idea how long it will take to load everything
While coping the data monitor the memory usage of both servers,
if it grows all the time that means the server is loading entire table into the memory.
The load might fail if server runs out of memory.
You can avoid this by splitting your transfers
eg select * from very large table where id <100000
select * from very large table where id between 100000 and 200000
You should also consider how to restart your data transfer
BTW what is your database types?
Mike
