How can we compare Business Central ERP to Front End Database System Data??

(0) Share

Report

Posted on by Bharath Kommuru

Hi Team,

During Deployment of release, is there any easy way to Compare the Business Central ERP data to Front end SQL database so that we will have data in Sync.

I appreciate your quick help on this.

Thanks & Regards,

Bharath Kumar K,

+14809314853.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Inge M. Bruvik 1,071 Moderator on at

Like (0)

Report

RE: How can we compare Business Central ERP to Front End Database System Data??

Why do you need such a sync? Are you running BC on prem or online?

Was this reply helpful? Yes No
Bharath Kommuru 5 on at

Like (0)

Report

RE: How can we compare Business Central ERP to Front End Database System Data??

Hi Inge M. Bruvik,

We are running BC on online only but we are loading Item data in Business Central and also in Front end database separately. We need to check whether there are any differences between this two systems from data perspective.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,071 Moderator on at

Like (1)

Report

RE: How can we compare Business Central ERP to Front End Database System Data??

You can not access the BC online database directly. You will have to pull date from that database through reporting / file export or API.

Are you only going to look at specific data in specific tables ?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 94,111 Super User 2025 Season 2 on at

Like (0)

Report

RE: How can we compare Business Central ERP to Front End Database System Data??

Hi, During development, if you want to confirm table data, it is most convenient to use the following method.

Viewing Table Data

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-view-table-data

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No