"schemaUpdateMode": "Synchronize"...

(0) Share

Report

Posted on by Muhammad Arif Maseed

782

Hi all,

I am working on AL i have created 1 table and one page when i publish the app more the one time on same version the data that i entered was lost even i did not make any change in table or page.

Even i used "schemaUpdateMode": "Synchronize" , i don't know why the data lost when the schemaUpdateMode = Synchronize.

any solution to safe the data ?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

ManishS 86 on at

Like (0)

Report
Copy link

Link copied!

That's surprising.

Had you used force to synchronize the changes.

Was this reply helpful? Yes No
Muhammad Arif Maseed 782 on at

Like (0)

Report
Copy link

Link copied!

sir how you use force in AL Extension V2.0 ?

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

The data synchronization between each publish of an extension is controlled by schemaUpdateMode setting, which is specified in the launch.json. This setting consists of two options; Synchronize and Recreate. The default value for schemaUpdateMode is set to Synchronize mode, which means that every time you publish an extension the data you entered is preserved.

If you don't want this, you can change the schemaUpdateMode setting from Synchronize to Recreate.

When you set the schema update mode to Recreate, all the tables and table extensions are recreated at every publish, which means that all the data in those tables are lost.

Was this reply helpful? Yes No
yannstlo 122 on at

Like (0)

Report
Copy link

Link copied!

Hi,

How about if I have 10 tables in my extension and only 1 is getting modified, do I have to loose the data in all the other tables? Is there a way to use the "schemaUpdateMode": "Recreate" on only 1 table?

What about in a production environment, how would you handle modifications to your tables without loosing your data?

Thanks

Yann

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

No way for a single table.

In a production environment, recreate is not possible, you need to always be backward compatible. In production you need to act as explained here:

[View:https://demiliani.com/2018/10/26/dynamics-365-business-central-handling-breaking-schema-changes-on-production/]

Was this reply helpful? Yes No