SQL DB impact of business central Sandbox with local container, and how docker manages SQL Database for the sandbox BC container.

Sumit Nandha Sumit Nandha

Sumit Nandha

Business Central || Navision

发布日期: 2023年9月3日
+ 关注

?

We will check the SQL DB impact of business central Sandbox local container, and how docker manages SQL Database for the sandbox BC container.

There are many articles available please check the below links containers image installation, so I am not going to show how to install and create containers for BC artefacts.

Useful links to understand and implement docker for business central

https://docs.docker.com/get-started/overview/

https://www.powershellgallery.com/packages/BcContainerHelper/5.0.6-preview1067

https://freddysblog.com/

This is how my container/Images look like

The customer table has 5 Records initially and it shows in Customer List Cronus UK company.

But when I check SQL DB, there is no table containing SQL Table with the name Customer.

But there are two Other db available in SQL and they contain Customer Tables.

Both contain 5 Records as we can see from the web client of Business Central.

To check-in details, I have created one test record in Business Central to see which db is impacted

Tenant DB, No record update

Default Db, record showing as 6 including newly created Records


To check the impact in detail, I have created one more company in the Sandbox Bc container.


Tenant DB impact No Tables are available for Newly created company

Default DB impact, Tables Are created with new Company in Default DB

Conclusion : Business Central container Sandbox is using Default Database to store Database in container SQL.

要查看或添加评论，请登录

Sumit Nandha的更多文章

  • AL namespace and SQL table fields.
    2023年9月27日

    AL namespace and SQL table fields.

    Hello readers, In the previous post, I try to explain what is the impact of NAV/ Business Central Table fields in SQL…

    3 条评论
  • Nos of table fields (NAV, BC 22.X, BC 23) in SQL
    2023年9月24日

    Nos of table fields (NAV, BC 22.X, BC 23) in SQL

    After hearing and reading many posts about improved performance with Business Central Version 23, companion table, and…

  • Runtime Packages for business Central App
    2023年9月12日

    Runtime Packages for business Central App

    Hello Readers, After the video from Erik Haggard’s YouTube session on “Protect your IP with Runtime Apps in AL and…

  • Emoji in Business Central ? ??
    2023年9月8日

    Emoji in Business Central ? ??

    Yes, emojis can be used in Business Central from AL Code as well as from the page. Recommending to use as only…

    1 条评论
  • Generating help with the ALDoc tool for Business Central Application
    2023年9月6日

    Generating help with the ALDoc tool for Business Central Application

    I will share with you some of the tips to generate Help document for your business Central custom Application below are…

    9 条评论

社区洞察

其他会员也浏览了