[DDLUTILS-156] Support for MS SQLServer 2005

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 1.3
• Component/s: Core - SqlServer
• Environment: MS SQL Server 2005 (version# 9)
• Assignee: Thomas Dudziak
• Reporter: Stefan Huber
• Created: 20/Feb/07 09:01
• Updated: 03/Nov/08 22:06

Description

SQL Server 2005 provides new large-value data types:

• varchar(max) replaces text
• nvarchar(max) replaces ntext
• varbinary(max) replaces image

A new Platform should be created to support these data types.
For details see http://msdn2.microsoft.com/en-us/library/ms178158.aspx

There is also a better schema support in this version and the builder methods (MsSqlBuilder.java) like dropTable, processChange, writeExpternalForeignKeyDropStmt, .. need to take care of that. Otherwise we might change elements (drop tables or FKs) from other schemas the user has access to!