DB Compare 1.7.2 Source

Rating: No reviews yet
Downloads: 965
Released: May 6, 2015
Updated: May 6, 2015 by Corby
Dev status: Stable Help Icon

Recommended Download

Source Code DB Compare Source Version 1.7.2
source code, 18424K, uploaded May 6, 2015 - 965 downloads

Release Notes

Updates for 1.7.2: (Includes cumulative updates for 1.6.2 - 1.7.1 which were not published due to the fact I never even get a review or a comment)
1. Check Constraints are now compared, and if a constraint returns multiple rows (Fields) than only one schema difference is reported.
2. I just recently found out Default Values are not populated so I have to query for that separately, so it may seem a little slower now on larger databases as it queries each field that is not auto increment for the default value.
3. There is now a checkbox 'Exclude Diagram Procedures' that is checked by default. If you view a diagram in a database it adds about 8 procedures to the database that probably would not get rolled out to production or test databases.

Update for version 1.6.1: Azure SQL does not support the table SysComments so my method for finding the function text had
to change to use Sys.allsqlmodules; further testing for Azure may be needed; when I move to production on our next release cycle I will do more Azure testing.

Updates for version 1.6.0: I now clear the text of the last comparison when a new comparison is started.
I also added a counter to list the number of schema differences.

I also started a Sync tool, I have this code commented out, but it is on my todo list
to create functionality to propegate the changes or create sql scripts to update the target database.

Reviews for this release

No reviews yet for this release.