The DevOps iteration feature of Data Management (DMS) lets you manage a database R&D process stage by stage. Each iteration maps to a template that defines the stages, the ticket types available at each stage, and the conditions required to advance.
A typical iteration follows this lifecycle:
Create an iteration — name it, assign a template, add participants, and select databases.
Create tickets at each stage — submit database change requests based on what the current stage allows.
Advance to the next stage — after all tickets in a stage pass their status checks, move the iteration forward.
Repeat until the iteration is complete or closed.
Prerequisites
Before you begin, make sure you have:
A DMS project with at least one iteration template configured. For details, see Manage iteration templates
One or more databases available in the project
Creator, project administrator, database administrator (DBA), or DMS administrator permissions to create and manage iterations. Other users can view iterations but cannot modify them
Create an iteration
Log on to the DMS console V5.0.
In the top navigation bar, click Database Development. In the left-side navigation pane, choose .
Click the Iteration tab.
Click Create Iteration.
In the Create Iteration dialog box, configure the following parameters, then click OK.
| Parameter | Description |
|---|---|
| Iteration Name | The name of the iteration. |
| Project | The project to which the iteration belongs. |
| Iteration Template | The template that defines all R&D stages, the advancement conditions for each stage, and the ticket types available at each stage. Each iteration can use only one template. You cannot change the associated iteration template after an iteration is created. To use a different template, create a new iteration. |
| Participants | One or more users who can create tickets and advance the iteration to the next stage. Only the iteration creator, project administrators, DBAs, and DMS administrators can add or remove participants. |
| Available Databases | One or more databases to use during the iteration. Only databases in the selected project are available. If no database is selected when you create the project, all databases of the current tenant can be selected. |
| Description | A description that helps you identify and manage the iteration. |
Create a ticket
Tickets represent database change requests. The ticket types available at each stage are determined by the iteration template.
Log on to the DMS console V5.0.
In the top navigation bar, click Database Development. In the left-side navigation pane, choose .
Click the Iteration tab.
Click the name of the iteration. The Iteration Details page appears.
Hover over Create Ticket and select a ticket type. A database can be selected for a ticket only if both conditions are met: The following ticket types are supported:
The database is listed as an available database for the iteration.
The database environment type meets the requirements of the current iteration stage.
Ticket type Description Change regular data Change data in tables and schemas. DDL-based lockless change Change the data of tables and schemas without locking tables. Import data Import data to a database in a quick manner. Change programmable objects by using stored routines Change data using functions and stored procedures. Design schemas Change schemas or create tables. SQL review Review SQL statements and get optimization suggestions. Synchronize schemas Sync schemas from a source database to a destination database. Initialize empty databases Sync schemas from a source database to an empty database.
Advance to the next stage
After completing all tickets in the current stage, move the iteration forward.
All tickets in the current stage must pass their status checks before you can advance. The specific checks are configured in the iteration template. Once you advance, you cannot create new tickets in the previous stage.
On the Iteration Details page, click Enter Next Stage.
In the confirmation dialog, click OK.
Repeat this process for each stage until the iteration is complete or closed.
Manage an iteration
On the Iteration Details page, you can update iteration settings and perform management operations.
Only the iteration creator, project administrators, DBAs, and DMS administrators can perform the following operations. Other users have read-only access.
Management operations:
Duplicate the iteration: Click Create As in the upper-right corner. In the Replicate Iteration dialog box, enter a name and description, then click OK.
View operation history: Click Operation History in the upper-right corner to see the timestamp, operator, and log for each operation.
Close the iteration: Click Disable Iteration in the upper-right corner, then click OK to confirm.
ImportantClosing an iteration is irreversible. You can duplicate a closed iteration, but you cannot reopen it.
Edit iteration details:
Iteration name: Click the
icon next to the iteration name.Description: Click the
icon next to Iteration Description.Project: Click the project name to view project details.
Participants: Click the
icon next to Participants to add or remove participants.Available databases: Click View next to Available Databases.
To add databases, select them in the Available Databases list and click the
icon.To remove databases, select them in the Available Databases list and click the
icon.
Iteration template: Click the template name to view template details. The template cannot be changed after the iteration is created.
What's next
Manage iteration templates — create and configure the templates that define iteration stages and advancement rules.