When an existing table is changed as a result of a .fob import, the new table definition is compared against the existing schema defined in the SQL Server database. The following message will be displayed (new in NAV 2017):
The options available for the Synchronize Schema choice are shown in this screenshot:
If we choose the first option, we will receive another stern warning message allowing us one last opportunity to cancel the import. If we tell the system to proceed, it will do so and, at the end of its processing, inform us of the results. More information on this process is available in Synchronizing Table Schemas (https://msdn.microsoft.com/en-us/dynamics-nav/synchronizing-table-schemas).
Warning
Using the Force option may result in a corrupted database where the data structure is out of sync with the application software. This may not be recoverable, except by restoring a backup. Using the Force option is especially risky in a production environment.
Using the Force option may result in a corrupted database where the data structure is out of sync with the application software. This may not be recoverable, except by restoring a backup. Using the Force option is especially risky in a production environment.