Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 751
  • 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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