DB Compare 2.0 is finally here!
I spent all my time off during the holidays and tried to have this release finished by New Year’s Day 2017. I finally finished, all but 10 days later than planned.
This is a major release of DB Compare as I added quite a few new features:
1. I added the ability to export the database schema to Xml and the ability to perform a comparison of the Xml against a SQL Server database.
2. I made a couple of speed improvements by reducing the number of round trips to the server; one query for all the tables versus querying for each table.
3. I now compare foreign key constraints
4. The stored procedure parameters and return set schema are loaded. Since the text of the stored procedures must match exactly, I didn’t add any code to compare the parameters and return set schema, although both are exported to Xml.
At my current day job, I must keep my local dev SQL Server database in sync with the databases on our dev, test and production servers. In the past I would script my entire local dev database and create a temporary database on whichever VM I was updating. This worked, but it was very time consuming.
Now with DB Compare 2.0, I simply export my local dev database to Xml and then perform a comparison on the VM I am updating against the Xml. Another nice feature of the Xml exporting ability, is you can export two databases to Xml and use a program like Diff or I use Code Compare because my company bought it for me, and view any differences in the Xml Files. This is actually more thorough than the comparisons performed by DB Compare.
The Xml comparison features were made possible by another open source project of mine:
Xml Mirror 2.0
https://xmlmirror.codeplex.com
I have tested the new version of DB Compare for a week or more now and I consider it stable. If you encounter any problems please report the problem on the Issues tab of the DB Compare project home on Code Plex or you may email me at corby@datajuggler.com.
I will do my best to answer all emails if possible.
Please note: If you are using the source code version in Visual Studio 2013, you may need to install the Dot Net Target Pack for version 4.61 from this link if you have not already done so.
https://www.microsoft.com/en-us/download/details.aspx?id=49978
Thanks,
Corby
