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
 > LATER
 > FORCE


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.

Regards,
Saurav Dhyani
https://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

Navision Cannot generate SSPI context State ID HY000

Hi all, Sometime while trying to connect database in classic client with windows authentication or connect to Role Tailored Client we face an error message. Error - The following ODBC error occurred: Error: [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context  State ID: HY000