This functionality is maintained for backward compatibility with older methodologies.
The current recommended methodology for introducing database changes is to check SQL scripts into a source control repository and then package them into changesets.
You can create changesets for database schema changes directly In the Datical DB GUI. The changesets are inserted into the changelog directly. When the changeset is successfully deployed, the databaseChangeLog table in the tracking schema is updated.
Any changes introduced using this method are not reflected in SQL code source control.
In the Datical DB GUI, do the following:
- Click a project (Deployment Plan) in the left column. Changesets you create are inserted into the changelog for this project.
- Click Add a Change Set.
- Select the type of changeset to create from the list. You can search types using the Filter box.
- Click Next
- Provide the information required by the changeset type. There may be several pages, depending on the type.
- Click Finalize.
- Provide changeset information for identification, labels, contexts, and deployment behavior.
- Click Finish.