Overview

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:

1. Click a project (Deployment Plan) in the left column. Changesets you create are inserted into the changelog for this project.
2. Click Add a Change Set.
3. Select the type of changeset to create from the list. You can search types using the Filter box. 
4. Click Next
5. Provide the information required by the changeset type. There may be several pages, depending on the type. 
6. Click Finalize. 
7. Provide changeset information for identification, labels, contexts, and deployment behavior. 
8. Click Finish. 

Most commonly used Change Set Types for newer Versions 7.9 and higher

• For Oracle use “Execute with sqlplus for Oracle Databases” in the “SQL Script Executors for Liquibase Business & Enterprise” section of the Changeset Wizard

• For SQL Server use “Execute with sqlcmd for Microsoft SQL Server & Azure SQL Databases” in the “SQL Script Executors for Liquibase Business & Enterprise” section of the Changeset Wizard (sqlcmd needs to be installed and pointed to by PATH environment variable)

• For Azure SQL use “Execute with sqlcmd for Microsoft SQL Server & Azure SQL Databases” in the “SQL Script Executors for Liquibase Business & Enterprise” section of the Changeset Wizard (sqlcmd needs to be installed and pointed to by PATH environment variable)

• For DB2 use “Execute with clpplus for DB2 Databases" in the “SQL Script Executors for Liquibase Business & Enterprise” section of the Changeset Wizard (clpplus needs to be installed and pointed to by PATH environment variable)

• For PostgreSQL use “Execute with psql for Postgres Databases” in the “SQL Script Executors for Liquibase Business & Enterprise” section of the Changeset Wizard (psql needs to be installed and pointed to by PATH environment variable)

• For EnterpriseDB use “Execute with edbplus for EnterpriseDB databases” in the “SQL Script Executors for Liquibase Business & Enterprise” section of the Changeset Wizard

• 

Most commonly used Change Set Types for older Versions 7.8 and lower

• For Oracle use “Execute with SQLPlus” in the “Oracle Utilities” section of the Changeset Wizard

• For SQL Server use “Execute with SQLCMD” in the “Other” section of the Changeset Wizard (sqlcmd needs to be installed and pointed to by PATH environment variable)

• For DB2 use “Execute with CLPPlus” in the “Other” section of the Changeset Wizard (clpplus needs to be installed and pointed to by PATH environment variable)

• For PostgreSQL use “Execute with psql” in the “Other” section of the Changeset Wizard (psql needs to be installed and pointed to by PATH environment variable)

• For EnterpriseDB use “Custom SQL (External File)” in the “Other” section of the Changeset Wizard

•