Good software to compare two databases in SQL

Asked By John S Blanding 20 points N/A Posted on - 08/05/2013

A good day to you TechyV support. I have a question for you today.

Where can I find a software to compare two databases in SQL?

I want to compare them including the schema and be sure that they are identical.

If you can ,please help me with this.

Also when providing me with the software, explain a bit how it works if you can.

Thank you

• Status: Open
• Question Views: 891
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Shell Scripting

Answered By Newman Gust 0 points N/A #174586

Good software to compare two databases in SQL

There are a host of software available to compare two SQL databases. A few of them are Red Gate, ApexSQL, AdeptSQL Diff, Open DBDiff and DBComparer. The last two tools are free however they are not without limitations.

I would recommend AdeptSQL Diff to draw comparisons between two SQL server databases. The software analyzes the two databases and gives a comparative schema tree view. Any differences in objects/components are highlighted by use of colors.

About Newman Gust

Questions
0

Answers
13

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/29/2013
• Question Category: Shell Scripting