Type NVarchar(max) not supported in the target db version
CodeDreamer68
Posts: 5
I get this warning message...
The type NVarchar(max) on object [dbo].[CPM_Projects].[ProjectDescr] is not supported in the target database version.
How do I change the target database version to SQL 2005?
The type NVarchar(max) on object [dbo].[CPM_Projects].[ProjectDescr] is not supported in the target database version.
How do I change the target database version to SQL 2005?
Comments
SQL Packager automatically selects the T-SQL formatting based on the version of the target server in an upgrade package. The SQL version can't be chosen manually. I hope that we can put the option in for a future version of SQL Packager, but for now, you must put the target database on a SQL Server 2005 in order to get a SQL 2005-formatted script that supports SQL 2005 datatypes.