Tool to compare two databases in different servers

Posted on 2010-09-08
Last Modified: 2012-05-10
Hi All,

I need your assistance. I am looking for a free tool to compare two databases in different servers to show the differences between the two databases such as missing tables, missing columns, different data types, nulls, etc.

I google this but there are a large number of tools to use.

Can you please let me know tools that you have used and that is worth downloading.

I prefer a free tool but if there is a tool that’s worth buying then let me know, as long that is not too expensive.



Question by:jose11au
LVL 26

Accepted Solution

Chris Luttrell earned 150 total points
ID: 33632462
I have used the Red Gate tools for several years.
They have a 2 week free trial to check it out.

Assisted Solution

gfuture4me earned 100 total points
ID: 33632513
I do vote for RedGate (an excellent tool to compare databases, but if you decide to buy it would be expensive), the option is if you have a MS Visual Studio Database Professional then you can compare the databases from the VS too...try it out.( it comes for 90 days free) so better than Red-Gate.

Assisted Solution

dpicco earned 100 total points
ID: 33632676
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.


Assisted Solution

auke_t earned 50 total points
ID: 33634445
Really like the RedGate tools, and with the free trial you can't go wrong
LVL 19

Assisted Solution

Rimvis earned 100 total points
ID: 33634661
You may check this one.Open DBDiff

Author Comment

ID: 33730059
Thanks for the all the help.


Author Comment

ID: 33730120
I am noy trying to close the question. I was awarding points to the guys who assisted with the question.

Please help.


Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql server query from excel 3 57
My Query is not giving correct result. Please help 5 30
Updating a table from a temp table 4 29
sql query questions 2 25
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now