The DevOps iteration feature of Data Management (DMS) allows you to advance an R&D process stage by stage. You can create specific types of tickets in each iterative stage. This facilitates collaborative development and makes the R&D process more efficient.

Create an iteration

  1. Log on to the DMS console.
  2. In the top navigation bar, move the pointer over the All functions icon and choose R&D Space > DevOps.
  3. Click the Iteration tab.
  4. Click Create Iteration.
  5. In the Create Iteration dialog box, set the parameters that are described in the following table and click OK.
    Parameter Description
    Iteration Name The name of the iteration.
    Project The project to which the iteration belongs.
    Iteration Template The iteration template that you want to use.
    • The iteration template contains all the stages of an R&D process.
    • The iteration template specifies the requirements that must be met in each iterative stage before the iteration is advanced to the next stage.
    • The iteration template specifies various types of tickets that can be created in each iterative stage.
    Note
    • Each iteration can be associated with only one iteration template.
    • You cannot change the associated iteration template after an iteration is created. If you need to change the iteration template, create another iteration.
    For more information, see Manage iteration templates.
    Participants The participant of the iteration. You can select one or more participants. An iteration participant can perform the following operations:
    • Create a ticket in each iterative stage.
    • Advance the iteration to the next stage.
    Note Only the creator of an iteration, project administrators, database administrators (DBAs), and DMS administrators can add or remove an iteration participant.
    Available Databases The database that you want to use during the iteration. You can select one or more databases.
    Note Only the databases that are available in the selected project can be selected. If no database is selected when you create the project, all the databases of the current tenant can be selected.
    Project Description The description of the iteration. Enter an informative description that can help you manage the iteration.

Create a ticket

  1. Log on to the DMS console.
  2. In the top navigation bar, move the pointer over the All functions icon and choose R&D Space > DevOps.
  3. Click the Iteration tab.
  4. Click the name of the iteration for which you want to create a ticket. The Iteration Details page appears.
  5. Advance the iteration.
    1. Move the pointer over Create Ticket and select a ticket type.
      Note The available types of tickets in each iterative stage are specified by the iteration template.

      For more information about how to create each type of ticket, see the references that are provided in the following table.

      Reference Description
      Change regular data Changes the data of tables and schemas.
      DDL-based lockless change Changes the data of tables and schemas without locking tables.
      Import data Imports data to a database in a quick manner.
      Use stored routines to change data Changes data by using functions and stored procedures.
      Design schemas Changes schemas or creates tables.
      SQL review Reviews the uploaded SQL statements and provides optimization suggestions.
      Synchronize schemas Synchronizes the schemas of the source database to the destination database to ensure consistent schemas.
      Initialize empty databases Synchronizes the schemas of the source database to an empty database.
      Note A database can be selected only if it meets both of the following requirements:
      • The database is selected as an available database for the iteration.
      • The type of the environment to which the database belongs meets the requirements of the iteration template.
    2. After operations are performed for all the tickets of an iterative stage, click Enter Next Stage. In the message that appears, click OK to advance the iteration to the next stage.
      Note
      • If a ticket fails the status check, the iteration cannot be advanced to the next stage. The rules that allow the iteration to be advanced to the next stage are configured in the iteration template.
      • After the iteration is advanced to the next stage, you cannot create a ticket in the previous stage.
  6. Repeat Step 5 until the iteration is complete or closed.

Manage an iteration

On the Iteration Details page, you can manage an iteration and modify the basic information about the iteration.

Note Only the creator of an iteration, project administrators, DBAs, and DMS administrators can perform the following operations. Other users have only query permissions on the iteration.
  • Manage the iteration.
    • To create a similar iteration, click Create As in the upper-right corner. In the Replicate Iteration dialog box, set the Name and Description parameters. Then, click OK.
    • To view the operation records of the iteration, click Operation History in the upper-right corner. You can view the operation time, operator, and operation logs of each operation performed on the iteration.
    • To close the iteration, click Disable Iteration in the upper-right corner. In the message that appears, click OK.
      Notice After the iteration is closed, you can create a similar iteration but cannot open the iteration again. Proceed with caution.
  • Modify or view the basic information about the iteration.
    • To modify the name of the iteration, click the 5编辑 (2) icon next to the iteration name.
    • To modify the description of the iteration, click the 5编辑 (2) icon next to Iteration Description.
    • To view the details of the project to which the iteration belongs, click the project name next to Project.
    • To add a participant to the iteration or remove a participant from the iteration, click the 5编辑 (2) icon next to Participants.
    • To add or remove databases that are available for the iteration, click View next to Available Databases.
      • To add available databases to the iteration, select the databases that you want to add in the Available Databases list and click the 5增加 icon. The databases are displayed in the Available Databases list.
      • To remove available databases from the iteration, select the databases that you want to remove in the Available Databases list and click the 5减少 icon. The databases are removed from the Available Databases list.
    • To view the details of the iteration template, click the name of the iteration template next to Iteration Template.