SQL Compare Bundle 2.03
Brian Donahue
Posts: 6,590 Bronze 1
Hi Chris,
Here are a list of the changes in the Red Gate SQL Bundle 2.03:
DTS Compare:
Added DTS Compare, formerly SQL Server Compare. DTS Compare lets you examine
and compare administrative attributes of SQL servers.
SQL Data Compare V2.03:
In the Utils class' AvailableDatabases and AvailableServers methods these
use to return variant type string arrays which will not not work with
VBScript, Now they use variant type Variant arrays that will - issue #43501
In the script produced insertions into DateTime fields were rounded up by 1
second if the milliseconds were over 500. Fixed now. Issue #43712
Fixed problem where REAL type data is converted to only 5 decimal places -
Issue #43989.
SQL Compare V2.03:
Where a column in a table has changed type from or to a UDT the CAST
operation used to transfer data now uses the UDTs underlying datatype.
In the Utils class' AvailableDatabases and AvailableServers methods these
use to return variant type string arrays which will not not work with
VBScript, Now they use variant type Variant arrays that will - issue #43500
ensured precision and scale is used with CAST to convert fields to type
decimal or numeric. Issue #43829.
Calling Utils.CreateHTMLReportEx2 now works with .NET. Issue #44005.
Public methods Utils.GenerateReportXML and Utils.GenerateReportXMLEx added
to return the HTML report's XML. Issue #44070.
Fixed problem where there is just a column added in the script (the table is
not fully rebuilt) the bindings for that new column (for a default or rule)
do not get added. Issue #44180.
Fixed problem where permissons do not appear for differring views. Issue
#45063
fixed problem with timeouts on dependecy scripting or foreign key data
retrieval during registration of database. #Issue 45218.
Fixed problem with script order of UDF dependant tables. This was because
UDF dependencies were being incorrectly described as table type dependencies
and not UDF type.
Fixed problem with conversion of NULL columns to NOT NULL (in output script
data transfer INSERT statement) where there is a default on the NOT NULL but
NULL data in the NULL column. Issue #46064.
Fixed equal line colour setting which didn't change with differing Windows
colour schemes - Issue #46465.
COMpare:
None.
Regards,
Brian Donahue
Technical Support Engineer
Red Gate Software Ltd.
+44 870 1600 037
mailto:brian.donahue@red-gate.com
"Chris Tybur" <ctybur@infinitevisions.com> wrote in message
news:3E10B9EF.2060100@infinitevisions.com...
> Will a list of changes/enhancements/fixes between 2.02 and 2.03 be made
> available, either here or on the web site? I'm interested in the
> upgrade, but I want to know what's in it before I install it.
>
> Thanks.
>
> Chris
>
Here are a list of the changes in the Red Gate SQL Bundle 2.03:
DTS Compare:
Added DTS Compare, formerly SQL Server Compare. DTS Compare lets you examine
and compare administrative attributes of SQL servers.
SQL Data Compare V2.03:
In the Utils class' AvailableDatabases and AvailableServers methods these
use to return variant type string arrays which will not not work with
VBScript, Now they use variant type Variant arrays that will - issue #43501
In the script produced insertions into DateTime fields were rounded up by 1
second if the milliseconds were over 500. Fixed now. Issue #43712
Fixed problem where REAL type data is converted to only 5 decimal places -
Issue #43989.
SQL Compare V2.03:
Where a column in a table has changed type from or to a UDT the CAST
operation used to transfer data now uses the UDTs underlying datatype.
In the Utils class' AvailableDatabases and AvailableServers methods these
use to return variant type string arrays which will not not work with
VBScript, Now they use variant type Variant arrays that will - issue #43500
ensured precision and scale is used with CAST to convert fields to type
decimal or numeric. Issue #43829.
Calling Utils.CreateHTMLReportEx2 now works with .NET. Issue #44005.
Public methods Utils.GenerateReportXML and Utils.GenerateReportXMLEx added
to return the HTML report's XML. Issue #44070.
Fixed problem where there is just a column added in the script (the table is
not fully rebuilt) the bindings for that new column (for a default or rule)
do not get added. Issue #44180.
Fixed problem where permissons do not appear for differring views. Issue
#45063
fixed problem with timeouts on dependecy scripting or foreign key data
retrieval during registration of database. #Issue 45218.
Fixed problem with script order of UDF dependant tables. This was because
UDF dependencies were being incorrectly described as table type dependencies
and not UDF type.
Fixed problem with conversion of NULL columns to NOT NULL (in output script
data transfer INSERT statement) where there is a default on the NOT NULL but
NULL data in the NULL column. Issue #46064.
Fixed equal line colour setting which didn't change with differing Windows
colour schemes - Issue #46465.
COMpare:
None.
Regards,
Brian Donahue
Technical Support Engineer
Red Gate Software Ltd.
+44 870 1600 037
mailto:brian.donahue@red-gate.com
"Chris Tybur" <ctybur@infinitevisions.com> wrote in message
news:3E10B9EF.2060100@infinitevisions.com...
> Will a list of changes/enhancements/fixes between 2.02 and 2.03 be made
> available, either here or on the web site? I'm interested in the
> upgrade, but I want to know what's in it before I install it.
>
> Thanks.
>
> Chris
>
This discussion has been closed.
