Failed Data Validation
Posted on 2011-05-07
I transferred a huge data ( over 3 million records ) from our old oracle server to our SQL Server which is configured as Merge Replication.
During data transfer from Oracle to SQL Server, the primary filegroup got full, so I increased its size then resumed data transfer, after that the data transferr completed successfully to our SQL Server, during that it was replicating to SQL Server subscribers.
The merge agent for the subscribers has finished replicating the new data successfully.
But when I tried to validate the data on the clients, row count was different for some tables!!
Is it possible that because of the filegroup error, the merge replication had some serious problem in keeping these tables in sync?
What is the best practice if I want to copy a huge data intto a merge replication topology?
How to be sure 100% that the data in all subscribers are accurate ? should I validate the subscriptions each time they syncronize?