How to safely rename physical entity name.
Hello,
Due to renaming a table in servicestudio before it went to production we got into a situation that a certain table has different physical names across the servers. This results in a problem building reports directly connected to de database from outside the platform.
Question is:
Is there a safe way to rename the table?
Losing the data in the table is not a problem and it is a static in this case.
Thanks,
Best regards.
Hi Michael Runhardt,
The safest scenario when renaming tables as far as I've seen, in the case where data could get lost, would be:1. Delete the original table in Service Studio and deploy the application.2. Run DBCleaner (Forge) to clean the metadata where the old table was referenced.3. Create the new table with the adjusted name.In summary, the best scenario will always be to create a new entity, rather than renaming it.Hope this helps.
Hello Michiel Runhardt
After renaming the table, OutSystems will take care of updating the database schema on all servers where the module is deployed. However, keep in mind that if there are any dependencies on the old table name in your application code, you will need to update those as well.
Since you mentioned that losing the data in the table is not a problem, you can safely delete the old table and create a new table with the same name as the renamed table. This will ensure that the new table has the same structure as the renamed table and any dependencies on the old table name are resolved.
Hi Michiel Runhardt,
Kindly check this link. It will help you.
https://www.outsystems.com/forums/discussion/65827/entities-name-in-backend-databases/
Ramesh