Generated SQL server script issues...

tonysell — Fri, 23 May 2008 12:25:19 GMT

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

Open Discussion & Feature Requests

Generated SQL server script issues...