Packaging SQL Scripts for Deployment

• Overview of Packaging
  • Liquibase Enterprise Labels
  • Liquibase Enterprise Contexts
  • Packaging Behavior with Frequent SCM Commits
• Placing Files in the SCM Repository
  • Choosing a Packaging Method
  • Fixed Folder Names
  • Flexible Folder Names
  • Custom Packaging Order
  • Packaging from a Manifest File
  • Oracle Database Objects and Packaging
  • SQL Server Database Objects and Packaging
  • PostgreSQL Server Database Objects and Packaging
• Writing SQL Scripts for Liquibase Enterprise
  • Creating Database Links in an Oracle schema with a non-owner account
• Packaging Liquibase Changelogs
• Developer Workflows: Managing Changesets During Development and Test
  • Best Practices for Developer Workflows
  • Effects During Merges
  • Path and File Attributes for Changesets
  • Abandoning and Restoring a Changeset: ignore and unignore
  • Changeset Versioning: version and versionStrategy
  • Cleaning Up Deployed Changesets: cleanup
  • Replacing Deployed Changesets: replace
  • Rollback Script Handling
• SQL Code Branching & Merging (Advanced)
• Configuring Packaging for Projects
  • Use the Required deployPackager.properties File
  • Using the metadata.properties file
  • Using the metadata-variables.properties file
  • Managing Database Backup and Restore
  • Configuring Deployment Packager to Use the Oracle Datapump API for Backup and Restore
  • Custom Backup and Restore Methods
  • Using SQL Parser
  • Configure Deployment Packager to Use the Oracle Flashback for Backup and Restore
  • Configure Deployment Packager to Use an Oracle Ephemeral Database
  • Configure Deployment Packager to Use a SQL Server Ephemeral Database
  • Configure Deployment Packager to Use a PostgreSQL Ephemeral Database

The Deployment Packager provides end-to-end automation for the onboarding of database changes in Datical DB with capabilities including: automated change validation & approval; source code control repository management; database environment backup & restore.