how to access database table in business central
how to access database table in business central
Hi, As other experts mentioned, with the SaaS version we don't have direct access to the database.
The On-Premises version can directly access SQL like the previous NAV.
Hope this helps as well.
Thanks.
ZHU
Hi
you cannot physically access a BC saas database
alternatively you can.
- check the data from the API
- back up the database in .bacpac format and restore it to an On-prem version
danieleincalza.blogspot.com/.../business-central-export-database-saas.html
DAniele
Hi,
refer the below link
https://erpconsultors.com/backup-of-business-central-d365-from-saas-tenant/
Regards
Amit Sharma
www.erpconsultors.com
Press Yes if Info is useful
do you mean SaaS/Online?
We do not have access to SQL database in Online but we can use APIs etc. for RIMD operations.
André Arnaud de Cal... 291,759 Super User 2024 Season 2
Martin Dráb 230,468 Most Valuable Professional
nmaenpaa 101,156