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.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers