Purpose of database synchronization

Finance and Operations/AX Developer Forum
1

HI Every one,

We do AX AOT database synchronization when ever we have data issues in AX. As I understood it tries to put

database and AX AOT tables equal. If for example If I delete some field in AX it also deletes same field in database.

I think this is Synchronization, Am I correct in this?

Can you eloborate your opinion on Data, Index and Views and What exactly database synchronization does

in AX.

Thanks

2

Yes, database synchronization creates/updates/delete objects in database to match the definition of tables, fields, views etc. in AOT. It generates normal SQL statements such as ALTER TABLE and executes them against AX database.

3

Thanks Martin, got it.
Does Synchronization also acts of Data of tables. Because if we have data issue we synchronize it. Can you please give example how it acts on data.

4

It’s all about structure. Of course, if you delete a table, for example, it will have impact on data (you’ll lose all data in that table), but it’s just a side effect of changes of your DB schema.