how to compare two tables data in different machines DB.

Question

0.00/5 (No votes)

See more:

I have tried to figure out through google and found the following query but its not worth for me.

SQL

SELECT * FROM db.sys.columns WHERE object_id = OBJECT_ID('db.SchemaName.table1')

I am using sql server 2005 and i am not using any linked database concept ,i can say one is server db and another is client DB . Both database are with same name and same structure but in different machine . i just need to mirror one database into another . For that reason first i need to check whether there is any new record in one DB.

Posted 17-Apr-13 0:23am

lalit.mca2006

Updated 17-Apr-13 1:25am

Shanalal Kasim

v4

Add a Solution

Comments

CHill60 17-Apr-13 6:28am

Firstly - Use the Improve question link to post the version of SQL Server that you are using as there are more tools available in later versions.
Secondly - have you set up either of the databases as a Linked Database to the other?

1 solution

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)

GuruprasadV · Answer 1 · 2013-04-26T21:15:00

Solution 2

To query across the Database servers you need to have linked server setup, if you cannot set the linked server.

You can load data from both server into once common server, then compare using SET operators like UNION, NOT EXISTS, alternatively you can use PowerPivot do to the same.

Posted 26-Apr-13 21:15pm

GuruprasadV