Data Management:Manage iterations

Create an iteration

1. Log on to the DMS console V5.0.
2. In the top navigation bar, click Database Development. In the left-side navigation pane, 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.
   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 V5.0.
2. In the top navigation bar, click Database Development. In the left-side navigation pane, 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.
      Change programmable objects by using stored routines	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 schema consistency.
      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.

• 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 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.
    Important 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 icon next to the iteration name.
  • To modify the description of the iteration, click the 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 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 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 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.