SQLDBControl 2.1, which contains bug fixes and minor modifications, is now available for purchase and evaluation.
Version 2.1 can be downloaded for evaluation from www.sqldbcontrol.com/download.aspx.
Version 2.1 requires .NET Framework 3.5 sp1, which enables us to offer full compatibility with SQL Server 2008.
IMPORTANT: An emergency fix has been added to release 2.1 that fixes a bug where tables that have indexes with included columns were showing up as different when they were not different. If you have build 2.1.00030 then download the latest build, which is 2.1.00040. You can check your build in Help > About.
Code Changes:
-
When displaying the summary list, objects that have only been deleted from source control (i.e. they still exist on the server) will be displayed by default. This behaviour can be changed by setting the Filter Deleted Objects option.
-
When performing a Get Latest from Server, if the object is checked out a before and after image of the definition is now stored against the object’s history.
-
When adding objects to a project from the Differences window, table dependencies are now obtained from the source control database.
-
When generating table change scripts for database-level comparisons, SQL 2000 specific scripts are now generated if the target database is SQL Server 2000.
-
When viewing Difference Reports, if a database is offline then the displayed status is “Database is Offline”.
-
When checking in a script, if no database connection is available, the script is still checked in.
Bug Fixes:
-
When generating change scripts for SQL 2000 tables, if a column data type was money an explicit conversion error would occur.
-
Fixed a bug where importing a script into a database would generate an exception.
-
Fixed a bug where, when scripting tables for deployment, tables that have dependants would be incorrectly scripted multiple times.
-
Fixed a bug where tables that have an identity seed or increment bigger than 1000000 and also have the NOT FOR REPLICATION option enabled, would incorrectly show up as Different in the Summary List.
-
Fixed a bug where an exception would occur when attempting to remove a project that had one or more Packages.
-
Fixed a bug where attempting to delete a checked-out table that had a default constraint on it would result in an exception.
-
Fixed a bug where attempting to create a new table in an empty database would cause an exception.
-
Fixed a bug where attempting to rename a server or a database would result in an exception.
-
Fixed a bug where renaming a table’s primary key constraint would not result in a correctly generated change script.
-
Fixed a bug where an exception would occur when deploying views.
-
Fixed a bug where checking in a table would sometimes result in any associated triggers been lost.
-
Fixed a bug where checking in a table in a SQL Server 2008 database would result in an exception.
-
Fixed a bug where scripting objects from source control would inadvertently introduce an additional carriage return to the end of objects definitions.
-
Fixed a bug where a syntax error would result when checking in a table that had associated triggers.
-
Fixed a bug where the data type sysname was not fully qualified in SQL 2005 or SQL 2008.
SQLDBcontrol Support
support@sqldbcontrol.com