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 10 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

5.1 Using SQL File ChangeSets.mp4

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