There are four videos on this page:
| Table of Contents |
|---|
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
...
Learn How Liquibase Supports Your Custom Rollback Scripts for Each Change
...