web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / What is the database b...
Small and medium business | Business Central, N...
Answered

What is the database behind Business Central?

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,848 Moderator

We have a client looking to possibly migrate to BC. We have a ton of customizations wrapped around their GP databases. What is the database behind BC? What programming tools are required for BC. We have class libraries written using VS C# which are tied to stored procedures.

I have the same question (0)
  • Suggested answer
    mahmoud_algindy Profile Picture
    mahmoud_algindy 281 on at
    RE: What is the database behind Business Central?

    Hi Richard,

    BC DB = SQL

    Coding with VS Code, the Language is AL Language

    Please refer to this link: docs.microsoft.com/.../devenv-get-started

    and Regarding Migrating to BC form GP please check this docs.microsoft.com/.../migrate-dynamics-gp

    Finally the ton of customizations wrapped around their GP databases.

    It's hard work, you need to make sure if BC will fit their needs and what are these customizations, as per my knowledge there are no way to migrate GP customizations to BC.

    Thank you

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: What is the database behind Business Central?

    Thank you, this is most helpful.

    Is there anything equivalent to SSMS in BC? How do you run ad-hoc queries?

  • Steven Renders Profile Picture
    Steven Renders 5,668 Moderator on at
    RE: What is the database behind Business Central?

    In BC Saas you don't get access to the SQL database, on-prem you can use SSMS.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: What is the database behind Business Central?

    We need to write a custom integration. How do we find out the data structures if we can't see the database?

  • Verified answer
    Steven Renders Profile Picture
    Steven Renders 5,668 Moderator on at
    RE: What is the database behind Business Central?

    BC uses the database to store the data, you won't find any meaningful table relations in the SQL database, they are in the AL layer.

    I suggest you start by having a look here:

    docs.microsoft.com/.../

    and focus on the API:

    docs.microsoft.com/.../

    And here for the data-structures and patterns:

    docs.microsoft.com/.../

    This might also be interesting:

    businesscentralbooster.com/.../

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: What is the database behind Business Central?

    Thank you so much for this. I have much to learn.

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.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,255

#2
Sumit Singh Profile Picture

Sumit Singh 2,665

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,401

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans