Hello everyone,
I am looking to clarify what occurs when an application is deleted from Outsystem using Outsystem SQL server DB. Will the DB be deleted? Additionally, if I re-import the application, will it use the same DB or create a new one?
Furthermore, I am curious if there is a method within Outsystem to safeguard against accidental application deletions.
Thank you.
Hi Drexxor,
When you delete an OutSystems application, the database tables created based on your entity model, and the data in it are NOT DELETED. Only if you use a tool like https://www.outsystems.com/forge/component-overview/5018/db-cleaner-on-steroids
you can actually delete the tables and data from the database for deleted entities.
When you delete an entity and the paste it again, a new table is created. A similar thing will happen if you import the app again and publish it. If you know the actual table names of before the app deletion, then you can change the OutSystems metadata to point to the original tables again.
There is a Forge component to find the physical table name of an entity:https://www.outsystems.com/forge/component-overview/2021/physical-table-name
You should put LifeTime governance and practices in place to avoid that colleagues can delete an application.
Regards,
Daniel
Hi Daniel,
Governance can be put in place but we still can't prevent accidental deletion. This is not something we can control.
Where can i change this?
If you know the actual table names of before the app deletion, then you can change the OutSystems metadata to point to the original tables again.
You can write an app that changes the meta data entities to let point your app entities again to the original tables.
https://success.outsystems.com/documentation/how_to_guides/data/data_migration_from_production_to_non_production_environment/outsystems_platform_metamodel/
Regarding deletion, yes there is no 100% safeguard, even if you have a developer could not delete the app, it could still delete all code or mess it up. I guess the right recruitment and coaching of developers is relevant to for them to not stupid things.
Hi Daniel, i think this is something we can suggest Outsystems to explore. One possible ways is to lock an application with a password . When an user attempts to delete an application, it will prompt for the password.