Announcements
No record found.
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.
Why do you need such a sync? Are you running BC on prem or online?
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.
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 ?
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 728 Super User 2026 Season 2
YUN ZHU 545 Super User 2026 Season 2
AndrewThomas81 328 Super User 2026 Season 2
