Click here to Skip to main content
13,043,898 members (48,379 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I have tried to figure out through google and found the following query but its not worth for me.

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
Updated 17-Apr-13 1:25am
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

Rate this: bad
Please Sign up or sign in to vote.

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.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 27 Apr 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100