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

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

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

Postby CodeDreamer68 » Wed Mar 25, 2009 5:09 pm

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?
Posts: 3
Joined: Wed Mar 25, 2009 4:57 pm

Postby Brian Donahue » Fri Mar 27, 2009 7:25 pm

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
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests