Liquibase Enterprise was formerly known as Datical DB.

Skip to end of metadata
  • Created by Former user, last modified by Former user on Jul 13, 2021
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

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 using deploy packager. 

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


  • No labels

Copyright © Liquibase 2012-2022 - Proprietary and Confidential