in

The ORM Foundation

Get the facts!

Generated SQL server script issues...

Last post 05-23-2008 8:25 by tonysell. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 05-23-2008 8:25

    Generated SQL server script issues...

    While generating SQL from a model I reverse engineered I have run into the following issues with some of the types from the original schema.  The following types do not seem to map correctly:

    XML --> ends up as a NATIONAL CHARACTERVARYING (NaN)

    NVARCHAR(max) --> ends up as a NATIONAL CHARACTERVARYING (NaN)

    binary and varbinary fixed length and (max) --> end up as BINARY LARGE OBJECT (0)

     SQL Server does not seem to like the "LARGE" or "(NaN)" portions of the script very much.  A quick search and replace gets the script to run, but the loss of distinction between the XML and nvarchar(max) types is a problem.  I am still playing around with them a bit to see what I can find, but wanted to post up and get a little feedback.  Are these types supported or is there a way to add custom types directly for either these or if user defined types are present?

    Thank You,

    --Tony

     

     

     

    Filed under: ,
Page 1 of 1 (1 items)
© 2008-2014 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service