Can Liquibase Enterprise automatically quote objects to preserve case?

Applies to: 

• Liquibase Enterprise (Datical)

Conditions:

• Any version of Liquibase Enterprise (Datical)

Question:

Can Liquibase Enterprise preserve the case of objects when deploying? 

Answer:

Yes, Liquibase Enterprise does have the ability to automatically quote the objects being deployed, which will preserve the case of the object.

Some databases will change the case to all uppercase or all lowercase if the object name isn't quoted, so if there is an object name that includes mixed case, you can either add an attribute to the changeset or add the quotes into the SQL file itself.

The attribute that you can add is objectQuotingStrategy="QUOTE_ALL_OBJECTS".

This attribute can be added using a checkbox when adding a changeset via the GUI.