RE: Is it possible to replicate Dynamics 365 Business Central Saas to either Azure SQL or On-Prem SQL
Hi Warric!
The easiest way to get your data out is using API's there are many standard API's you can use to access your data. You can also create custom API's for data that is not covered by the standard API's.
So using API's to extract data and store them in a local DB og Azure DB is not very hard. The API is used by the standard system for reporting in Power BI.
You can also sync your data with Dataverse (common data service) i would recommend that way if you are working with really large amount of data that needs to be frequently updated.
Some documentation on the API's
docs.microsoft.com/.../
And some on Business Central an dataverse:
docs.microsoft.com/.../admin-common-data-service
You can also export your online database and set it up on prem - but that is a manual process for each time and not very good for regular sync
docs.microsoft.com/.../tenant-admin-center-database-export
I hope this helps you further.