Hi,

which method is a faster way to transfer data from one server to another server at difference location?
currently i using normal task to do a transfering, it take a about an hours to transfer about 5000 record for one table only.
it is not a better way for me to do a transfering. i need do a transfer data as transfer data in same location.

any idea ?


thanks and Regards

Jane

Can you be more specific with your task

1. normal task ? what does this mean?
2. Are you transferring the entire database
3. how big is your database
4. How are you connecting to your other location and the speed of your connection?



Jaime E. Maccou

oh.. sorry!

I using OLEDB provider for SQL server to do transfering.

set one oledb for server1 set another oledb provided for server2, then used coommand as this select * from table


i not transfer entire database, only new record will be updated to the other server. both server already have a same database and table.

thaNK YOU!