I am a big fan of SQL Delta (http://www.sqldelta.com/) and in the time I have been using the trial version have found it to be very useful and far better than the Schema Compare tool in Visual Studio. I ran across one annoying (but easy to fix) problem: it does not know about the datetime2 data type in SQL Server 2008 and it punts when it encounters that type in your database objects.
The fix is pretty simple: when scripting tables that have columns of type datetime2, manually enter the type in the nice, empty space SQL Delta places there where the type ought to be.
My trial has since run out so I never got the opportunity to see if there is a way to configure or add new types for it to recognize, but that would be a pretty cool feature, wouldn't it?
Print | posted on Tuesday, March 31, 2009 4:55 PM