• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 749
  • 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.

Thanks.

Jose

0
jose11au
Asked:
jose11au
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.
0
 
gfuture4meCommented:
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.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

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

Please help.

Jose
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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