Sunday, March 11, 2012

compare records

Hi,
We have 2 sql server on different location. Records are synchronized.
Checked the number of records on one table and some data are not copied. How
can I compare the records in a table on both servers , list only the records
that is non-existent on the other server. and eventually copy only those
missing records.
Thanks for any help!
Benny,
How are you synchronizing the records? Replication? Log shipping? If you
doing either of those, I wouldn't do an out of process synchronization. It
could really mess things up.
If you want to compare, you can attempt a link server and compare the two
tables, but depending upon your network connection, this could be
unworkable.
Bill
"Benny" <Benny@.discussions.microsoft.com> wrote in message
news:BC74991E-1869-45BC-9215-6068FDDC4240@.microsoft.com...
> Hi,
> We have 2 sql server on different location. Records are synchronized.
> Checked the number of records on one table and some data are not copied.
> How
> can I compare the records in a table on both servers , list only the
> records
> that is non-existent on the other server. and eventually copy only those
> missing records.
> Thanks for any help!
|||check out http://www.dbghost.com
"Benny" wrote:

> Hi,
> We have 2 sql server on different location. Records are synchronized.
> Checked the number of records on one table and some data are not copied. How
> can I compare the records in a table on both servers , list only the records
> that is non-existent on the other server. and eventually copy only those
> missing records.
> Thanks for any help!

No comments:

Post a Comment