Red Gate forums :: View topic - SQL Toolkit version 6 released

Go to product support center

SQL Toolkit Previous Versions forum

SQL Toolkit version 6 released

Search in SQL Toolkit Previous Versions forum

This topic is locked: you cannot edit posts or make replies.

Jump to:

Author

Message

Brian Donahue

Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software

Posted: Wed Jul 11, 2007 10:30 am Post subject: SQL Toolkit version 6 released

Red Gate is proud to announce the release of version 6 of SQL Toolkit. This version introduces new features to the SQLCompare Engine:

Message.SeverityComparer class evaluates severity of warnings/messages
Database.SaveToFolder method Saves the database as a set of creation scripts to the specified folder.
Database.LoadFromStream method Load a database from a System.IO.Stream object
Database.RetrieveCaseInformationFromLiveDatabase method returns true if the database in question is case-sensitive
Database.Register method is now overloaded. The new overload accepts a file path, ReadFromScriptDatabaseInformation class, and options. This allows reading in a schema from a folder full of scripts that have a .sql file extension:

Code:

ReadFromScriptDatabaseInformation scriptInfo = new ReadFromScriptDatabaseInformation();
scriptInfo.CaseSensitive = true;
scriptInfo.DefaultOwner = "DBO";
scriptInfo.SQLServerDBVersion = 90;

widgetProductionScripts.Register(@"c:\widgetdevscripts", scriptInfo, Options.Default);

Note that setting scriptInfo as null will use default options.

Sample code is now available for Visual Studio 2005 and is available for download separately from our website, by clicking the appropriate link on the main page of the SQL Toolkit. This allows us to keep the examples more up-to-date.

The following bugs have also been addressed:

Data Compare samples raise LoaderLock warning on .NET2
Less-than-graceful handling of non-EMCA-compliant assemblies
Length or precision specification 0 is invalid when migrating CLR function with nvarchar(max)
Indexers on PartitionFunctions and PartitionSchemes collections return null after snapshot load
Assemblies which depend on each other are scripted in an incorrect order
SQL Compare reports CLR Procedure Parameters as nvarchar(0) instead of nvarchar(max)
IGNORE WITH ORDER having side effects
SQL Compare doesn't clean up its temp files
System.NullReferenceException in SQLCompare.Engine.BlobStore when viewing XML Schema Collection
Does not cancel during register for data compare
Error saving snapshot file
CLR Assemblies containing multiple files make sync fail
The SQL for orphaned windows users is incorrect
"CLR: Got ""Corrupt metadata tables header"" exception..."
SQL Compare does not detect extended properties on DRI defaults
Database could be IDisposable

_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

Display posts from previous:

	All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum