Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 3,377
Jainam M. Kothari 2,696 Super User 2025 Season 2
YUN ZHU 1,512 Super User 2025 Season 2
