The new SQL Data Compare beta is about to be released and I hope you all get a chance to have a good look at it and send me your opinions. There are a few features that we are quite proud of mostly of course these are surrounding our new Yukon support, SQL Server 2005 as now released. We’ve been working away internally on this for quite a while so we’re keen to get valuable feedback to make the upcoming release our best ever.
If you would like to join the beta program just send me or Neil Davidson an email and we’ll put you on the list.
The main features that I personally would like for people to have a look at are…
CLR Object type support in SQL 2005. XML type support and especially migration from existing XML fields you may have stored in [n]text fields or [n]varchar fields. Better collation support, there have been problems in the past with sort orders of varying collations in SQL Data Compare especially the older SQL_ collations that you may still use in your data. If you’ve been experiencing problems this release should fix them all for you. XML and partitioned indexes in SQL 2005. Large object SQL generation has been changed quite significantly to address users concerns so hopefully should produce quicker-to-execute SQL scripts.
This product just keeps getting better and better, I know because I write a lot of the code for the engine part of it :).
Have fun peepsicles.