Skip to main content

NAV 2015 - Changes in Schema Synchronization - Part 1.

Hi all,

One more major change which was a pain in NAV 2013 R2 have been enhanced in NAV 2015. Below are the Changes in Schema Synchronization in NAV 2015.

In Microsoft Dynamics NAV 2015,
Microsoft have introduced a number of improvements to the schema synchronization process that make it more explicit, more granular and controllable, providing you with the flexibility of deciding when and how your table changes should be synchronized with corresponding SQL tables.

So What is schema synchronization?

Any Change we do in Navision developer Environment related to Tables Need to be updated in SQL Server Database. That is What is called as Schema Synchronization.

Below Picture Might Help Those who are still Unaware about it.

Till NAV 2013 The Schema Synchronization used to happen directly from Developer Environment / Classic Client to SQL Database.

With Release of NAV 2013 R2 we had a feature known as Multitnenacy, due to which Schema synchronization is now done via Service Tier. There were quite a few challenges / Issues in NAV 2013 R2 related to Schema Synchronization.

What used to happen in NAV 2013 R2 ?

AUTOMATIC - Schema synchronization executed automatically on any connection to Microsoft Dynamics NAV Server

What Will Happen in NAV 2015 ?

Schema synchronization executed on demand by Microsoft Dynamics NAV Server

So if its now on Demand, Next question comes to my mind is - How do I synchronize table changes?

Any Change in Tables (ONLY TABLES) will pop-up with a New save Window as shown below -

Where you have an Option field to Choose for Synchronization Schema. (Discussed Later)

The Types of Changes are listed Below -

> Save
> Save As
> Compile (also for multiple tables)
> Delete (also for multiple tables)

What if i want to Synchronize all Objects (Tables)?

Option A > Tools – Sync. All Table Schema Changes
Option B > Import FOB

Remember - System tables are synchronized by the Development Environment, not by Microsoft Dynamics NAV Server.

The Synchronize Schema have three Options during Changes in Tables (ONLY Tables) -

 > NOW

In next Post we will discuss about Options of Synchronization Schema, Destructive Table Changes, Upgrade Codeunits, Modes in Upgrade Codeunits, Powershell Commands & benefits of New Schema Synchronization in NAV 2015.

Stay Tuned for More about #NAV 2015.

Saurav Dhyani


Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

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 -