BC SaaS web services read only replica or production

(1) Share

Report

Posted on by Samantha73

2,437

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:

Business Central

All responses (3)

Answers (2)

Verified answer

YUN ZHU 73,565 Super User 2024 Season 2 on at

Like (0)

Report

BC SaaS web services read only replica or production

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
gdrenteria 12,167 Most Valuable Professional on at

Like (1)

Report

BC SaaS web services read only replica or production

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
Verified answer

Judy Microsoft Employee on at

Like (1)

Report

BC SaaS web services read only replica or production

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