Disclamer
The sample scripts provided on this page are for the purpose of demonstrating the features of RED and are not considered production ready, please use these scripts at your own risk and adjust them to suit your own environment as required.
Export Objects - Metadata, Create DDL, Scripts, Procedures and Templates
This example script will combine the Workflow Script feature with the command line tooling of RED to output metadata to a flat file structure useful for GIT integration, here are the steps performed:
- Create an output directory structure that represents the Object Tree in RED
- Run WslMetadataService.exe and extract each Object's metadata to a json file with a .metadata extension
- Run a RedCli batch script that outputs:
** Procedure, Script and Template files for each Object in the Context
** Generates and outputs Create DDL as .ddl files for each Object in the Context
There are two Scripts involved:
- 'Export Objects' Workflow Script - This is a wrapper to execute the main script in a separate thread so that RED UI is not locked.
- 'wsl_workflow_export_objects_example' Powershell script