SQL Delta diff tool problem with datetime2
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...
SQL Server scripting woes
For the past few days a co-worker Geoff and I have been working on setting up database object creation scripts in a SQL Express 2008 environment, and we ran into two issues where the script generation tools built into SQL Server Management Studio have some unexpected behaviors that were tripping up the process. In one case there was a silent failure to perform a particular scripting task and in the other there was a loud failure that seemingly was unrelated to the configuration of the scripts we were attempting to generate. In both cases we were able to...