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, you can configure the Knowledge Base so that it blocks any change that isn’t backward compatible, among other configurations.
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