Altering Databases - Integration Tab

Specifies database settings that determine how Microsoft Dynamics NAV integrates with SQL Server and external tools.

To open this window, on the File menu, choose Database, choose Alter, and then choose the Integration tab.

Objects Options

Field Description

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.

Maintain Relationships

Determines whether SQL Server creates and maintains a foreign key constraint for each TableRelation property of a Microsoft Dynamics NAV table.

If you select this option, then external tools have access to the table relationships (foreign key constraints) that exist between the Microsoft Dynamics NAV tables. These relationships are disabled and are not used to enforce data integrity but are intended for modeling purposes only.

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.

Maintain defaults

Determines whether SQL Server creates and maintains default constraints for each field in a Microsoft Dynamics NAV table. If you select this option, then external tools can use the default contstraints when they insert data into or modifying data in Microsoft Dynamics NAV tables.

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.

License Options

Field Description

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.

See Also

Tasks

How to: Alter Databases

Concepts

Altering Databases - General Tab
Altering Databases - Database Files Tab
Altering Databases - Transaction Log Files Tab
Altering Databases - Collation Tab
Altering Databases - Options Tab
Altering Databases - Advanced Tab