BC SaaS web services read only replica or production

(1) Share

Report

Posted on by Samantha73

3,247

Hi All

When creating new web services by exposing pages and queries for reporting, does the Azure SQL use a read-only replica of the database or the production

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Judy Microsoft Employee on at

Like (1)

Report

Hi Sir,

When creating new web services by exposing pages and queries for reporting, Azure SQL Database can use either a read-only replica of the database or the production database itself, depending on the configuration and requirements of your application.

What is the Azure SQL Database service? - Azure SQL Database | Microsoft Learn

Read queries on replicas - Azure SQL Database & SQL Managed Instance | Microsoft Learn

Best Regards,

Judy

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,217 Most Valuable Professional on at

Like (1)

Report

Hello good afternoon
I hope these links can help you, you can use the DataAccessIntent property for this task.

Manage database access intent in Business Central - Business Central | Microsoft Learn

DataAccessIntent Property - Business Central | Microsoft Learn

2023 Wave 2 – v23: Report read-only data access – Gerardo Rentería Blog (gerardorenteria.blog)

Attention to this note:

best regards

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,432 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the following helps.

Dynamics 365 Business Central: Managing Database Access Intent (Managing write access to APIs from the client)

https://yzhums.com/19105/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No