Type NVarchar(max) not supported in the target db version

[CodeDreamer68]

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?

[Brian Donahue]

Hi Charles,

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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521