How To: Use Storage Settings

Owned by Former user (Deleted), created
Last updated: Apr 12, 2021
1 min read

This article discusses the Storage Settings option for a database and how users can decide when to use it.

Functionality

This Storage Settings property controls whether or not storage options are collected for a specific database definition during the snapshot command. Storage Option information includes storage configuration, tablespace/filegroup assignments, large object storage parameters and partitioning information for tables and indexes.

If the Storage Options is set to “true”, Liquibase Enterprise will keep storage information in <ddb_project>/Resources/<schema>/storage.

Instructions

The Storage Settings option is located on the dbDef in the datical.project. By default the option is set to “false”. It can be updated by the following methods:

  1. GUI checkbox for Storage Settings

  2. Updating the datical.project file directly: storageOptionCollectedAtSnapshot="true"

Use Cases

  1. If your database pipeline has different tablespace names across databases, you likely will want to keep Storage Settings set to “false”. With the setting set to “true”, Liquibase prepends tablespace names to items such as indexes during the convert packaging method. This means your script may work in REF but when deploying to databases with different tablespace names you may get Tablespace Not Found errors.

Documentation

 

Copyright © Datical 2012-2020 - Proprietary and Confidential