Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I use dbConstructor to normalize the prefix and or suffix object naming conventions of existing databases?

April 26, 2017conventions databases dbconstructor existing naming normalize object prefix suffix

0

10 Posted

How can I use dbConstructor to normalize the prefix and or suffix object naming conventions of existing databases?

1 Answer

0

10 Posted

This requires the user to import an initial version of the database with the “Name Generate” check box in the “Project/Version Details” tab unchecked, then creating a new version of the database by clicking on the “Version/New Version” menu option and clicking the “OK” button in the “New DB Schema Version” dialog. Once the version is created the user then re-imports the database over the new version making sure that the “Name Generate” check box in the “Project/Version Details” tab is now checked. The last step requires the user to create a “Version Synchronization” script and run this script against the working database. Doing the above steps in addition to normalizing the prefix and suffix naming conventions also synchronizes the working database with imported database and any future alterations to the working database can be handled by dbConstructor.