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
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
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.
- 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