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?

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Steven Renders 5,686 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suvarna on at

Like (0)

Report
Copy link

Link copied!

Hi Steven,

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

Was this reply helpful? Yes No
Suggested answer

Stefan Sosic 35 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suvarna on at

Like (0)

Report
Copy link

Link copied!

Hi Stefan,

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

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,686 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No