Lost Connection Between Data Dictionary and Applications After Database Conversion

Scriptcase 9 General
#1

Hi everyone,

I recently migrated one of my Scriptcase projects from PostgreSQL to MariaDB, and during the process, I encountered an issue with the Data Dictionary no longer linking properly to my applications. Here’s a summary of what I did:

  • I originally generated all forms and language labels using the tables and views from a PostgreSQL database.

  • Due to PostgreSQL’s use of the public schema, all application and field labels were prefixed with it.

  • I renamed all the applications, adjusted the SQL settings, and updated all relevant scripts accordingly.

  • To clean things up, I deleted the existing Data Dictionary and removed the associated Project Messages from the Application Language.

  • I then created a new Data Dictionary and synchronized it.

  • After recreating the Project Messages, I attempted to synchronize the applications with the dictionary. However, I received the message: "No application found."

As a result, I had to manually update all field labels in every application, which was very time-consuming.

My questions:

  1. Is there anything I can do now to restore the connection between the applications and the new Data Dictionary?

  2. For future projects, what would be the correct and safe way to approach a database conversion like this (especially when schemas and naming conventions differ)?

Any insights or best practices from those who’ve handled similar transitions would be greatly appreciated.

Thanks in advance!

#2

check which driver you using for MariaDB. I know for fact that MySQL driver and MariaDB driver are not the same. Compare that with what real database you running on the server/or locally.
I have had some issues with that, then when replaced the drivers it all worked.
NETMAKE also have had some issues with MariaDB drivers (some bugs which they confirmed with me) so unsure if they are already fixed.

#3

Thank you for your response. However, I don’t quite see how the database is related to the linking between the Data Dictionary and the Applications. From my perspective, this appears to be an internal Scriptcase development issue.
That said, I may be mistaken—could you please clarify?

#4

I was getting some errors in the past. The errors came from the SC Libs. After contacting NETMAKE they suggested to switch from MySQL driver to MariaDB driver. After that the errors disappeared. It is because locally I was running XAMPP (which used MariaDB) but I used driver for MySQL.
Not sure if this is your case but it will not hurt to try.