I have two MS SQL 2000 databases residing in two servers. In one server, In one of the tables I have 1 million records. What is the fastest and efficient way of transferring data from one server to another. I tried the DTS. But the problem with DTS is that there is no way of knowing whether the target server contains the source records already. In other words, we do not want duplicate records in the target database.

Is there something like data synchronization or so available for MS SQL Server 2000?