Check integrity data in distributed database

Please tell me the way to check data integrity between server1 and server2 in distributed database
( Do we have a tool like that in SQL Server ?)
Thank a lots.
Hi there Tuan,
What do you mean with data integrity? Do you mean to check if two databases
are identical?
Andrs
"Tuan Anh" <anonymous@.discussions.microsoft.com> wrote in message
news:8E4AE8AB-6773-4A8A-B4CA-B1E1417C7D6B@.microsoft.com...
> Please tell me the way to check data integrity between server1 and
server2 in distributed database
> ( Do we have a tool like that in SQL Server ?)
> Thank a lots.
|||Hi Andrés,
When we do a distributed trasaction between server1 and server2, there may be have some prolems such as network failure or careless action of users. So data on server1 is not correct with data on server2.
For example:
On server1: OrderID (primary key) ProductName
001 A
On server2: OrderID ( primary key) ProductName
001 B
Clearly, the data on server1 unfit one on server2. So how can we know this difference if it occurs ?
sql