Please note the script of the presentation is below so you can read along with the video if you like.
Please note. This is a re-release of BIDA0042 – Business Central Tables And Columns Rename Script so that the post will be sent to the Business Central Community.
Hello and welcome to our latest blog post.
I am really pleased you have come back to see our latest news!
I am pleased to bring you some news that I hope will interest you.
I am Mihai Neacsu and I am the business development manager here at BIDA.
Today we have some good news for all those people who use Business Central on premise.
If you have Business Central on Premise and find it hard to write SQL against the underlying database?
We have some good news for you.
As you know, Business Central contains GUIDs in table names.
It also has field names that require brackets around the field names in almost all cases.
This makes writing SQL against the underlying database more difficult than it needs to be.
Today we are pleased to announce the release of an SQL Script that renames all tables and columns in the Business Central 2023 Release Wave 2 demonstration database.
You can run this script, start to finish, against the Demonstration 23 database of Business Central.
Just so you know, we used the Cronus UK database to create this script.
But it is easily edited to run against any other version of Business Central 2023.
We have tested it against that database and it works without error.
You can download this script from the button below and try it out for yourself.
Of course, if you are on a different level of Business Central, or you have customized your Business Central, you have two options.
1. You can alter the script by hand.
2. You can send us your SQL Server dictionary tables and we can quickly run the process on a server here.
To make it more interesting for you?
We will do this script generation work for free for the first 20 companies who contact us and ask us to do that.
After the first 20?
We might ask to be paid a small fee just for our time.
We have implemented this script as part of developing our data warehousing product for Business Central on Premise.
This table and column renaming will make it a lot easier for us to build our data warehouse.
It will also make it a lot easier for us to develop SQL Direct Query Dashboards against Business Central.
We hope you will download and try out this script and consider using it in your company.
And with that?
I would like to say thank you very much for reading or listening to our blog post today.
I really appreciate your time and attention.
We hope you found this blog post interesting and informative.
We would love to hear your comments, so please feel free to use the comments section below.
I wish you a great day.
Thank you.
Mihai Neacsu
BIDA Business Development Manager.
We will be emailing our subscribers useful and
valuable information regarding business intelligence.
Please subscribe here to be on our general emailing list.
