How to: Alter Databases

You can change the database property settings that you selected when you created the database.

The Alter Database window gives you access to the same settings as the New Database window.

To alter a database

1. In the development environment, on the File menu, choose Database, and then choose Alter. The Alter Database window opens. In the Alter Database window you can change database settings.

   The Alter Database window contains the following tabs:

   • 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 - Integration Tab

   • Altering Databases - Advanced Tab

2. Restart the Microsoft Dynamics NAV Server instance.

   The changes will not take effect until you restart the Microsoft Dynamics NAV Server instance. For more information, see How to: Start, Stop, Restart, or Remove a Microsoft Dynamics NAV Server Instance.

3. If you alter the collation settings, then you must do the following:

   1. Synchronize the table schemas in the database. You can do this from the development environment or Microsoft Dynamics NAV 2015 Administration Shell.

      • From the development environment, on the Tools menu, choose Sync. Schema For All Tables, and then choose With Validation and follow the schema synchronization instructions.

      • From the Microsoft Dynamics NAV 2015 Administration Shell, open the Microsoft Dynamics NAV 2015 Administration Shell as an administrator, and then run Sync-NavTenant cmdlet. For more information, see How to: Run the Sync-NAVTenant Cmdlet to Synchronize the Tenant Database with the Application Database.

   2. Restart the Microsoft Dynamics NAV Server instance.

      For more information, see How to: Start, Stop, Restart, or Remove a Microsoft Dynamics NAV Server Instance.

See Also

Reference

Alter Database