Creating and Managing Pipelines
A pipeline must be created to run and version DDL queries via DBRunner. The pipeline created on this page includes the projects on the Project page. The executed DDL queries are deployed to environments sequentially and versioned. Pipeline management is important in this regard. Each pipeline can cover a single project, or it can be created by adding multiple projects sequentially. The baselines to be created are also managed here.
After creating a new pipeline, you can select the Create Project option on the page you are directed to and add the relevant project after the pipeline.
Things to keep in mind here:
-
The services must be installed under the relevant project. This is only required for Oracle databases. (Explained under "Adding a Database")
-
Each project can be added to a single pipeline.
-
After adding a project, user information must be re-entered on the connection detail page. The users running DML and DDL queries can be the same or different.
A project added to a pipeline can be associated with any Git account and branch. This will only push the relevant objects to the relevant Git branch when a baseline is created.
When you click on the Pipeline title and create a new deploy, you can select either New Version or Create Baseline. Selecting New Version will open a page with the steps to upload files to run DDL queries on the database.
