BC SaaS web services read only replica or production

(1) Share

Report

Posted on by Samantha73

3,317

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)

Sort by

Verified answer

Judy Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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... 27,056 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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 101,995 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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