In the Building Stage, GeneXus analyzes schema changes and generates:
- Database reorganization programs, and
- A script with the corresponding SQL Statements.
You could package that reorganization programs using specific MSBuild Tasks and/or copy the scripts to the project. The latter can also be automated by configuring what MSBuild Tasks to trigger after the Building process is complete, and by configuring Build Events in the Knowledge Base.
Additionally, the Knowledge Base can be configured to block any changes that are not backward compatible. For example, if there is already a dedicated process responsible for handling database reorganizations, you can set the Keep GAM database updated property to False and the Reorganize server tables property to No, ensuring that the deployment process does not alter the database structure.
If you are using SQL Server 2019 Database projects as a way to obtain dacpac files that hold your Database model, you can use the CreateDatabase MSBuild Task to automatically generate the creation script of the Database, and integrate the generated script with your SQL Server Database project to obtain the dacpac during the CI process.
Features of Reorganizations