Altering Databases - Integration Tab

Maintain Views

Determines whether SQL Server creates and maintains a view for each language ID that is added to a table or field in Microsoft Dynamics NAV.

If you select this option, then external tools can use the SQL views to gain access to the CaptionML property of the object in the required languages instead of the name that is supplied in the table.

Synchronize

Is linked to the Maintain Relationships setting and is active only if you have already decided to create and maintain the table relationships on SQL Server.

This option is available only after table relation errors have occurred when you were restoring a database or importing some objects into a database. For example, the table relation problems can be resolved by deleting the table relations that refer to nonexistent tables and then using this option to synchronize the table relations with SQL Server.

If table relation errors occur when you are restoring a database, the restore will not be stopped.

Convert Identifiers

Defines characters that you want to map to the underscore character in the names of all SQL Server objects, such as tables, columns, and constraints. If these characters occur in tables or fields in Microsoft Dynamics NAV, then they are converted to underscores in the SQL Server names.

When the conversion is complete, you must close and reopen the database before you can use the new identifiers.

Save license in database

Specifies that the license file is uploaded and stored in the database instead of on the server. This is useful if you are hosting several databases with separate license files on the same server.