Packaging is the first step in the deployment workflow. Packaging is the process of getting SQL scripts refactored and deployed to the first database in the project workflow. By convention the first database is the REF database.
...
The Deployment Packager can be run from the CLI or the GUI. You provide a configuration file for the project that specifies the options to use during packaging. See Using the required deployPackager.properties file.
Packaging Sources
You can package SQL scripts from the following sources.
- Source Code Management (SCM) Repository: Place SQL scripts in a defined location in a source code repository. Configure a properties file with information about source code management repositories where SQL scripts and the Datical DB Project reside. During processing, the Deployment Packager reads the properties file and gets the SQL scripts from the SCM.
- Manifest File: Define a manifest file to identify the SQL scripts to be processed and provide metadata about the scripts. The manifest file is passed to the Deployment Packager.
Workflow
Deployment Packager uses the following workflow for changes checked into an SCM. When packaging with a manifest file, the manifest file specifies the files to package (steps 1 and 2 below).
...
Writing SQL Scripts for Datical DBWriting
...
SQL Server Database Objects and Packaging
Oracle Database Objects and Packaging
How To: Choose Between CONVERT (ddl) and DIRECT (sql_direct) Packaging Methods
What is the difference between "ddl" and "sql_direct" folders?