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.
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
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
Post a Comment