Red Gate forums :: View topic - SQL Toolkit version 6 released
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Toolkit Previous Versions
SQL Toolkit Previous Versions forum

SQL Toolkit version 6 released

Search in SQL Toolkit Previous Versions forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6577

PostPosted: Wed Jul 11, 2007 10:30 am    Post subject: SQL Toolkit version 6 released Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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


Powered by phpBB © 2001, 2005 phpBB Group