Skip to Content

Which logical type would be mapped to nvarchar(max)?

I am currently working on a logical model which I have to convert to a SQL Server 2012 physical model.

What data type do I have to use in the logical model to have it converted to nvarchar(max) automatically in the physical model?

Or should I pick one (text) and simply change the type in the physical model to nvarchar(max)?

In the DBMS properties for SQL Server 2012 under Script->Data Type->AmcdDataType VMBTMAX is mapped to nvarchar(max), however, I don't know how to assign VMBTMAX to the attribute in the logical model. One other option would be to select Variable Multibyte and set the length to 2147483647.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers