• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 752
  • Last Modified:

Tool to compare two databases in different servers

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.



5 Solutions
Chris LuttrellSenior Database ArchitectCommented:
I have used the Red Gate tools for several years. http://www.red-gate.com
They have a 2 week free trial to check it out.
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.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Really like the RedGate tools, and with the free trial you can't go wrong
You may check this one.Open DBDiffhttp://opendbiff.codeplex.com/
jose11auAuthor Commented:
Thanks for the all the help.

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

Please help.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now