I installed Microsoft Dynamics NAV 2016 and for reasons of internet connection (unstable connection), I had to proceed to two standalone installations of the solution on both sites of the client who is very distant.
Currently, I am coding an ETL with SQL Server for periodic synchronization of data from the subsidiary to headquarters.
I want to know what precaution to take (G/L Entry table):
- To insert subsidiary data without overwriting or replacing headquarters data?
- To change the branch data already synchronized to reflect changes that occurred after the last synchronization.