Solved

Tool to compare two databases in different servers

Posted on 2010-09-08
7
738 Views
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.

Thanks.

Jose

0
Comment
Question by:jose11au
7 Comments
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 150 total points
ID: 33632462
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
 
LVL 1

Assisted Solution

by:gfuture4me
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.
0
 
LVL 3

Assisted Solution

by:dpicco
dpicco earned 100 total points
ID: 33632676
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 9

Assisted Solution

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

Assisted Solution

by:Rimvis
Rimvis earned 100 total points
ID: 33634661
You may check this one.Open DBDiffhttp://opendbiff.codeplex.com/
0
 

Author Comment

by:jose11au
ID: 33730059
Thanks for the all the help.

Jose
0
 

Author Comment

by:jose11au
ID: 33730120
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

770 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