Data Lossed after synchronization of tables

Business Central/NAV Technical Forum
1

Hello to all ,

We had lost the data from few tables as well as few tables are drop after we synchronized tables from SQL administrations.

Is it realted to the AOI file?Anybody knows the reason behind this issue ?

Regards

GAnesh Sahane

2

Hi Ganesh,

Some of the tables get dropped from the database side if their reference entries are deleted at the AOT level.

3

Hi Abhinay

Thanks for replay .We loss all the data from few tables , also table which are droped are not related to that table during sync.

Regrads

Ganesh Sahane

4

Hi Ganesh,

After you make changes in the tables from the SQL, you need to save these changes from the classic client first during this period if any of the changes happen through the classic client, the modifications from the SQL will get lost.

5

Hi Mantri ,

Thanks for replay. :slight_smile:

Mantri what do u mean by classic client? The tables which are droped , most of them are not in use so there are no chances to update thm frm sql .What happaned is we deleted the AOI file before synchronization , so i m trying to find out the is it bcoz of we deleted aoi file ?

Regards

Ganesh Sahane