Solved

Tool to compare two databases in different servers

Posted on 2010-09-08
7
731 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
Comment Utility
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
Comment Utility
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
Comment Utility
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 9

Assisted Solution

by:auke_t
auke_t earned 50 total points
Comment Utility
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
Comment Utility
You may check this one.Open DBDiffhttp://opendbiff.codeplex.com/
0
 

Author Comment

by:jose11au
Comment Utility
Thanks for the all the help.

Jose
0
 

Author Comment

by:jose11au
Comment Utility
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

743 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

15 Experts available now in Live!

Get 1:1 Help Now