Data Sync between Azure SQL DB and Dynamics Business Central? RRS feed

  • Question

  • I have several Dynamics BC including SQL Server and looking for way to collect data for EDW.

    1) Is it possible to sync data to Azure SQL DB? And it is ok practise?

    2) Is is possible to add T-SQL Trigger to SQL DB instance even there are no triggers in BC? 


    Saturday, June 15, 2019 8:34 PM

All replies

  • Good day,

    1. the most common service is Azure SQL Data Sync.

    In addition your can use replication, Azure data Factory, SSIS, Geo-redundant, Zone-redundant , and more....

    2. I am not familiar with Dynamics Business Central, but if you control the database then the answer is yes. The triggers if well developed are not related to the application side and the application does not have to know that they are there if it does not count on it 

    signature   Ronen Ariely
     [Personal Site]    [Blog]    [Facebook]    [Linkedin]

    Sunday, June 16, 2019 1:44 AM