Skip to end of metadata
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 14 Next »

There are four videos on this page:

Overview of Adding a Script & Deploying it Through The Pipeline

The following video takes you through the process of adding a script to an SQL Server project and promoting it to downstream environments. Highlights of this video include an overview of Changeset settings used to control where and when a Changeset is executed; examples of Liquibase Deploy reports and logs; and an introduction to the Liquibase Business status capabilities.

ChangeSet Types to use with Version 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

ChangeSet Types to use with Version 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

Video about Adding a Script & Deploying it Through The Pipeline:

Learn How Liquibase Supports Your Custom Rollback Scripts for Each Change

5.2-Rollback for SQL File Changesets.mp4

Learn How to Control Where Scripts are Deployed by Using Labels & Contexts

5.3 - Labels and Contexts.mp4

Learn More About Other Settings in the Change Set Wizard

54 - Optional Settings2.mp4
  • No labels