N/APosted 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.
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.