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

check sql database for business central

(0) Share

Report

Posted on by Suvarna

Hi,

I want to connect SQL database for Business Central in Microsoft SQL Server Management Studio. How to do it? If not possible then any other way where I can see all the tables?

All responses (5)

Answers (0)

Suggested answer

Steven Renders 5,500 Moderator on at

Like (0)

Report

RE: check sql database for business central

Yes, go in BC and look for the page: Table Information:
Suvarna on at

Like (0)

Report

RE: check sql database for business central

Hi Stefan,

Thanks for your reply. Yes .. it's working.
Suggested answer

Stefan Sosic 35 on at

Like (0)

Report

RE: check sql database for business central

Hi Suvarna,

For only checking data in tables you could find table Id which you need from All Objects With Caption page:

And afterwards access table by putting &table=tableId.

For example:

http:// containerURL/Instance/ ?tenant=default&table=17

Don't forget to help the community by verifying the answer or at least like the suggestion if it did help in any way. It will let others know that the topic has verified answer and was beneficial to you.
Suvarna on at

Like (0)

Report

RE: check sql database for business central

Hi Steven,

Thanks for your reply. Is there any other way where I can see tables and data all together?
Suggested answer

Steven Renders 5,500 Moderator on at

Like (0)

Report

RE: check sql database for business central

If you are using BS Saas, then it's not possible. You don't get access to the DB in BC Saas.

If you are using BC On Prem, then simply connect to the SQL Datbase configured in the NST.