Extra info in creating database...

Hanney

Hi there..
when i want to create a new database, in the new database windows,in the integration tab
under Objects, there have four check box..what for maintain defaults, maintain views, maintain
relationships?
can any one explain that.. :-k i create a new database using finsql.exe

Thank you..

DenSter

Just leave the default values in there. Those are SQL Server specific settings, and none of them are very important for NAV databases.

garak

From the online help.

Entering Information in the New Database - Integration Tab
The Integration tab contains database settings that influence the way Navision integrates with SQL Server and external tools. These options can be changed later.

This tab contains the following database settings:

Objects

Maintain Views: This setting determines whether or not SQL Server will create and maintain a view for each language ID that is added to a table or field in Navision.

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

Maintain Relationships: This setting determines whether or not SQL Server will create and maintain a foreign key constraint for each TableRelation property of a Navision table.

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

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

This option is only available after table relation errors have occurred while you were restoring a database or importing some objects into a database. The table relation problems can be resolved by, for example, deleting the table relations that refer to non-existent 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 aborted.

Maintain defaults: This setting determines whether or not SQL Server will create and maintain default constraints for each field in a Navision table. If you select this option, external tools can use the defaults when inserting data into or modifying data in Navision tables.

Convert Identifiers: This setting allows you to select the invalid characters in the names of all the SQL Server objects (tables, columns, constraints) in the database that you want to map to the underscore character. The Remove characters field contains a list of the characters that are converted to underscores. You can modify this list.

When the conversion is completed, the database must be closed and reopened before you can use the new identifiers.

License

Save license in database: This setting allows you to specify 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. If you select this option when you are creating or altering a database, you will be prompted to upload the license file to the database.

For more information about views, table relationships and identifiers in the SQL Server Option, see the Application Designer’s Guide.

For more information about these settings and about per-database licenses, see the manual Installation & System Management: Microsoft Business Solutions–Navision SQL Server Option.

Don't change the default values if you not need it (or you not know what they do, and test it before if you make changes ;-) )