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

1 Answer

  • Dec 13, 2018 at 03:03 AM

    In the LDM, select datatype of Other in the Standard Data Types window and enter VMBTMAX in the code field.

    Since you would need to manually enter the text, I would create a Domain with datatype VMBTMAX and then associate the domain with the entity attribute.

    1. Create a domain
    2. Click the ellipsis to open the Standard Data Types window
    3. Select Other
    4. Enter VMBTMAX in the Code field
    5. Associate the Domain with the entity attribute(s)
    Add comment
    10|10000 characters needed characters exceeded