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