Hello. I have to compare the values from 1 table from one database and 1 table from another database in the same server. Can anyone suggest how to do this?

I do not want to use any third party tools. I need to do this programmatically - only with sql server and C# and if there is a possibility to use only sql server.

Just fully qualify the tables.

Something like this:

SELECT t1.*, t2.* from [Database1].[dbo].[table] t1
JOIN [Database2].[dbo].[table] t2 on t1.column = t2.column

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

Thanks a lot. That was very helpfull.

Just fully qualify the tables.

Something like this:

SELECT t1.*, t2.* from [Database1].[dbo].[table] t1
JOIN [Database2].[dbo].[table] t2 on t1.column = t2.column

It looks like you have solved the problem. If not and your tables are really big and you need to find only the different rows you can use scripts which do that.
It is completely SQL,
http://www.sqlservercentral.com/scri...laneous/30221/


G.R.Preethiviraj Kulasingham