Activity overview
Latest activity by nharris
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...
Datetime2(0) columns get deployed as Datetime2(7)
SQL Compare version 10.0.0.179 - when deploying changes from source control to a database, columns with data type datetime2(0) get created simply as datetime2. This uses the default precision, maki...
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!
Extended properties not retrieved correctly in ver 2.1.0.220
Having just installed SQL Docs version 2.1.0.220, I have found that the descriptions of tables and their columns are not retrieved from the database but are all shown as "RedGate.SQLCompare.Engine....