Skip to content

Latest commit

 

History

History
59 lines (41 loc) · 2.84 KB

synchronize-tenant-database-and-application-database.md

File metadata and controls

59 lines (41 loc) · 2.84 KB
Raw
title description ms.custom ms.date ms.reviewer ms.service ms.topic author
Synchronize the Tenant Database with the Application Database
This article describes how to synchronize the business data (tenant) database schema with the application database in a single tenant or multitenant deployment environment
bap-template
evergreen
04/01/2021
jswymer
dynamics-365-op
conceptual
jswymer

Synchronizing the Tenant Database with the Application Database

This article describes how to synchronize the business data (tenant) database schema with the application database in either a single tenant (non-multitenant) or multitenant deployment environment. You can synchronize the database from the [!INCLUDEnav_dev_long] or by using the Sync-NAVTenant cmdlet in the [!INCLUDEadminshell].

Synchronize database from the Dynamics NAV development environment

APPLIES TO: [!INCLUDEprod_short] Spring 2019 and earlier.

  1. Open [!INCLUDEnav_dev_short] as an administrator.

  2. On the Tools menu, choose Sync. Schema For All Tables, and then choose With Validation and follow the schema synchronization instructions.

Synchronize database with the Sync-NAVTenant cmdlet

  1. On the computer that is running the [!INCLUDEserver], run [!INCLUDEadminshell] as an Administrator.

    1. Choose Start, in the Search box, type [!INCLUDEadminshell].

    2. Right-click the related link, and then choose Run as Administrator.

  2. At the command prompt, type one of the following commands:

    • If the [!INCLUDEserver] instance isn't configured to be a multitenant instance:

      Sync-NAVTenant –ServerInstance <ServerInstanceName>

    • If the [!INCLUDEserver] instance is configured to be a multitenant instance:

      Sync-NAVTenant –ServerInstance ServerInstanceName -Tenant TenantId

    Change the following parameter values.

    Parameter Description
    ServererInstanceName Specifies the [!INCLUDEserver] instance.
    TenantId Specifies the ID of the tenant.

  3. Select Enter to run the cmdlet.

See Also

Converting a Database.md
Upgrading the Database
Multitenant Deployment Architecture