Solved

Tool to compare two databases in different servers

Posted on 2010-09-08
7
742 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Re-appearing SQL Server Agent jobs 7 29
SQL Activity Monitor detail 2 24
Database ERD 4 27
query linked sql table field from access 4 20
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

856 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