Hello and welcome! I am Mihai Neacsu and I am the Business Development Manager here at BIDA.
We are very pleased you are dropping by to see our latest blog post.
This blog post is intended to be our first post that makes it to the Business Central Forums for partners.
So this is a test.
If the test works? We would like to give you a valuable freebie for finding us!
That freebie is a renaming script for Business Central 2023 Wave 2.
You can listen to the video below and click on the button below to download the whole script.
It will give you easier to use and remember names for all the tables and fields in Business Central. We hope you like it.
And with that?
We are going to post this blog post and see if we have our very first blog post make it to the Business Central Blogs.
Please note the script of the presentation is below so you can read along with the video if you like.
(Note. We have swapped my photo for the cartoon character. I hope you like it!)
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.
