You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Stefan Huber (JIRA)" <ji...@apache.org> on 2007/02/20 10:01:48 UTC

[jira] Created: (DDLUTILS-156) Support for new data types in MS SQLServer 2005

Support for new data types in MS SQLServer 2005
-----------------------------------------------

                 Key: DDLUTILS-156
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-156
             Project: DdlUtils
          Issue Type: New Feature
          Components: Core - SqlServer
         Environment: MS SQL Server 2005 (version# 9)
            Reporter: Stefan Huber
         Assigned To: Thomas Dudziak
            Priority: Minor


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
 


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Updated: (DDLUTILS-156) Support for MS SQLServer 2005

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DDLUTILS-156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Dudziak updated DDLUTILS-156:
------------------------------------

    Fix Version/s:     (was: 1.1)
                   1.2

> Support for MS SQLServer 2005
> -----------------------------
>
>                 Key: DDLUTILS-156
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-156
>             Project: DdlUtils
>          Issue Type: New Feature
>          Components: Core - SqlServer
>         Environment: MS SQL Server 2005 (version# 9)
>            Reporter: Stefan Huber
>            Assignee: Thomas Dudziak
>             Fix For: 1.2
>
>
> 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!
>  

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Updated: (DDLUTILS-156) Support for MS SQLServer 2005

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DDLUTILS-156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Dudziak updated DDLUTILS-156:
------------------------------------

    Fix Version/s: 1.1

> Support for MS SQLServer 2005
> -----------------------------
>
>                 Key: DDLUTILS-156
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-156
>             Project: DdlUtils
>          Issue Type: New Feature
>          Components: Core - SqlServer
>         Environment: MS SQL Server 2005 (version# 9)
>            Reporter: Stefan Huber
>         Assigned To: Thomas Dudziak
>             Fix For: 1.1
>
>
> 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!
>  

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.