Hi,
How do I develop a program to compare data on schema? Currently, I'm using a Visual Studio Data Comparison which I see the comparison was very fast and include of matching each data.
How to code for SQLDataCompare as the tools using C# or VB.NET? I would like to run it as program and at timer tick, it will compare and update if it detect a differential record.
What I have tried:
Currently, I made a program to compare based from count on both server. If there is different, the I will SELECT TOP <n> * FROM <tables>
Not so proper. But to compare each data line by line, I don't know how long it would take since there is one table contains more than 1 millions data..