Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In both cases, after successful packaging job, scripts move into “archive” folderWhen using these packaging folders, the sql scripts are moved into the "archive" folder near the end of a successful packaging job.


Scripts in “DDL”:

Each script in “ddl” directory (when using the "convert" packaging method that is the default for the ddl folder) goes through a process during packaging called “convert SQL”. The output of the “convert SQL” is XML changeset that defines EVERY change of the object derived from a script. The benefit of “convert SQL” is that Datical can forecast these changes during forecast operation. Here is what a “convert SQL” generated changeset would look like. Notice that we identify creation of the table along with each column in the table.

...

How To: Choose Between CONVERT (ddl) and DDL_DIRECT (ddl_direct) Packaging Methods

Writing SQL Scripts for Datical DBLiquibase Enterprise#CONVERT/ddlfolderversusDIRECT/sql_directfolder

Overview of Packaging

Fixed Folder Names#ProcessingChanges

...