Skip to main content

NAV 2013 R2 - How to Sync Tenant?

Hi all,

A common Command referred in many of the Forums that can be used to Sync Changes of Navision in SQL is Sync Tenant.

Most of us are not aware how to run this command. In this post we will see how to Run and When to Run this Command?

When to Run?

A- When Upgrading Database from NAV 2009 / NAV 2009 SP1 / NAV 2009 R2 to NAV 2013 R2.

After Opening Database in NAV 2013 R2, Compiling System Tables and Importing Merged Objects of NAV 2013 R2.


RUN SYNC Tenant.  

B- When Importing a FOB contain so many objects and Major Changes in Tables.
As SQL stores the data and Table Structure so if you have Major Table Changes in the Imported FOB.
 
RUN SYNC Tenant.

Why to Run?

- With Release of NAV 2013 R2, the changes from Navision to SQL Occurs in Two Cases -

A) Any Client Activity like Opening a Page, Running RTC Client.
B) Running NAV Sync Tenant Command.

I would Still prefer the Way of Sync Tenant as most of the Time While Trying to Update SQL Using Running RTC Client, client get Timeout and operation Fails.

Where to RUN?

Sync Tenant Runs on the Middle Tier (Service Tier) of the Three Tier Architecture?

How to RUN ?

1. OPEN ISE As Administrator.

2. Load the Command Let for NAV 2013 R2.

-----------------------------------------------------
#Prepare PowerShell
Import-Module 'C:\Program Files\Microsoft Dynamics NAV\71\Service\NavAdminTool.ps1'
-----------------------------------------------------

If you Require Assistance in above Steps Refer Here

3. Run the Below Command to Sync Tenant.
-----------------------------------------------------
#Sync Tenant Where Service Name that connect to Database is DynamicsNAV71
Sync-NAVTenant -ServerInstance DynamicsNAV71
-----------------------------------------------------

OR Make as query as shown Below after Step 1 & 2.

3) Refresh the Command Bar and Search for Command Sync-NAVTenant. Specify the Service Instance and Click Run as shown below.



4) On the Status Bar you will see the status of the sync, once the Status Changed to Completed it means that changes from NAV to SQL are completed.


I hope you find the information above useful and will help you while importing last set of objects and during upgrade Process.

Regards,
Saurav Dhyani
www.sauravdhyani.com

Comments

Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

Dynamics 365 Business Central 2021 release wave 2 (BC19) Released.

Hi Readers, As we all were expecting Microsoft have Released Business Central 2021 Release Wave 2 Today a.k.a BC19. In this article we will see what all is announced with the General Availability.  Starting Today Customers & Partners can start using Business Central 19. #msdyn365bc #bc19

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------