Comments
Sort by recent activity
OK, guess it was because I was taking a shortcut by deploying from TFS to a new, empty database on the server without it being linked. Presumably it assumes an earlier version of SQL Server than 2008?
I just tried linking the DB and creating a test table containing a datetime2(0) column and SQL Compare created a deployment script with the correct column data type definition.
Thanks,
Nigel. / comments
OK, guess it was because I was taking a shortcut by deploying from TFS to a new, empty database on the server without it being linked. Presumably it assumes an earlier version of SQL Server than 20...
Yes, that seems to have sorted it. Thanks for the quick response! / comments
Yes, that seems to have sorted it. Thanks for the quick response!