Compare SQL data programmatically

Question

0.00/5 (No votes)

See more:

, +

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..

Posted 4-Sep-16 23:31pm

Luiey Ichigo

Updated 5-Sep-16 2:55am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

NaibedyaKar · Answer 1 · 2016-09-05T02:30:00

Solution 1

There is a SQL compare tool from Redgate that you can try. Of course it is not free. You might check the trial version of it.

If you really want to do it pro grammatically, then I would recommend you to use JOINs. That might be little efficient for you.

Else I afraid you have to load 2 tables and then start comparing inside your C# code.

Posted 5-Sep-16 2:30am

NaibedyaKar

Updated 5-Sep-16 2:42am

Comments

Luiey Ichigo 5-Sep-16 22:03pm

I was not encourage to use 3rd party software to be run on clients. The programming is the best way, but to accomplished it,is the hard way since I can't find one tutorial for this. But I have seen this JOIN things in here:
http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx

Just wondering how to put those query to JOIN on both local and cloud server into one connection to perform it. Do you know how VS2015 Data Comparison works? I mean, how it be done to until there is view of Identical Record, Differential Record, Only in Sources/Target..

Maciej Los · Answer 2 · 2016-09-05T02:55:00

Solution 2

Whatever you mean by "compare data on shcema", i'd say it isn't simple job. Check this: CodeProject Knowledge Base[^]

Posted 5-Sep-16 2:55am

Maciej Los