Skip to Main Content
Feature Request FR-3977
Product Area Developer Experience
Status CLOSED

4 Voters

Generate upgrade script on supporting objects from database

rodrigo.batistella Public · Aug 23 2024

Idea Summary
Today “Upgrade scritpts" can only be created manually (from scratch or from file), but install scripts can be generated/updated using database objects. 

My idea is 

1 - to have a list of objects not to include in the automatically generated scripts

2 - To have a table to store the scripts already applied (install and/or upgrade scripts)

3 -  Each time the install script is refreshed APEX would add an upgrade script automatically with the newly created objecs and the modified objects since last script (using last_ddl_time from user_objects view). The condition to run can be automatically generated using the table that stores the executed scripts.

4 - Every time a script is executed during import or manually the name of the script is stored in the scripts applied table

Use Case
This would enable developers to maintain the supporting objects automatically.

This request is likely a duplicate of FR-3270.

Comments

Comments

  • rodrigo.batistella OP 1.3 years ago

    all ddl commands could be stored in a table using a trigger and these scripts could be generated based on them. APEX could present a screen previewing all the commands and letting the user choose which will be included in the install/upgrade scripts.