Small and medium business | Business Central, N...

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:

Business Central

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 73,565 Super User 2024 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
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 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 ?
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.
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 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?