Page Comparison

In some cases you may need to override the default packaging behavior for SQL script processing order.

...

1. Place a metadata.properties file in the top of the SQL code tree. It must correspond to the directory specified in the sqlScmSQLBaseDir property in the deployPackager.properties file.  
2. Use the folderOrder property in that metadata.properties file to specify a list of folders.  Files in the folder are pulled to the front of the list of files to package, ahead of files in other directories.  .  (Note that if you use custom folderOrder, the commit time will not be considered as part of the overall ordering.)

Examples: Specifying Packaging in a Multiple Schema Project

...

• Files matching the filter are moved to the front of the list of files to package. The process is repeated for each value, in order.
• The sorting takes place after the baseline packaging order is determined using the packageOrderStrategy property. 
• Any file in the list that does not match one of the filters is processed after the ordered files and according to the packageOrderStrategy setting
• This method is intended as an extension to be used with the PACKAGEMETHOD and ALPHANUMERIC strategies. (It is not intended to be used with DEFAULT stategy.)

SQL Code Folder Organization and Packaging Strategy for the Examples

...