Manage iterations

Create an iteration

1. Log in to DMS 5.0.

2. In the top navigation bar, choose Database Development > R&D Space > DevOps.

   Note

   If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the console and choose All Features > Database Development > R&D Space > DevOps.

3. Click the Iteration tab.
4. Click Create Iteration.
5. On the Create Iteration page, configure the following parameters and click Confirm.

   Configuration Item	Description
   Iteration Name	Enter a name for the iteration.
   Project	Select the project to which the iteration belongs.
   Iteration Template	Select the target iteration template. The iteration template contains the stages of the development process. The iteration template specifies the conditions that must be met to advance to the next stage. The iteration template determines the types of tickets that can be created in each stage. Note An iteration can be associated with only one iteration template. You cannot change the iteration template after an iteration is created. To switch to a different template, create a new iteration. For more information, see Create an iteration template.
   Participants	The one or more participants of the iteration. 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, DBAs, and DMS administrators can add or remove an iteration participant.
   Available Databases	The one or more databases that you want to use during the iteration. 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 in to DMS 5.0.

2. In the top navigation bar, choose Database Development > R&D Space > DevOps.

   Note

   If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the console and choose All Features > Database Development > R&D Space > DevOps.

3. Click the Iteration tab.
4. Click the name of the target iteration to open the Iteration Details page.
5. Advance the iteration through its stages.
   1. Click Create Ticket and select a ticket type.
      Note The types of tickets that you can create in each stage are determined by the iteration template.

      For more information about ticket operations, see the documents in the following table.

      Ticket type reference	Description
      Data Change	Change table data and table schemas.
      Lock-free Change	Change table data and table schemas without locking tables.
      Data Import	Quickly import data into a database.
      Programmable Object	Change functions and stored procedures.
      Schema Design	Change table schemas or create tables.
      SQL Review	Review uploaded SQL statements and provide optimization suggestions.
      Schema Synchronization	Synchronize the table schema of a source database to a destination database to ensure schema consistency.
      Empty Database Initialization	Synchronize the table schema of a source database to an empty database.

      Note A database can be selected only if it meets the following conditions:

      • The database is in the list of available databases for the iteration.
      • The environment type of the database matches the type defined in the iteration template.
   2. After you complete all ticket operations for a stage, click Enter Next Stage, and then click Confirm to advance the iteration to the next stage.
      Note

      • If the stage advancement check fails, you cannot advance the iteration. The conditions for stage advancement are defined in the iteration template.
      • The approvers for iteration advancement can be customized in the iteration template. For more information, see Create an iteration template.
      • After the iteration is advanced to the next stage, you can no longer create tickets in the previous stage.
6. Repeat Step 5 until the iteration is complete or closed early.

Manage an iteration

On the Iteration Details page, you can manage the iteration and edit its basic information.

• Manage the iteration.
  • Create As: Click Create As in the upper-right corner of the page. In the Copy Iteration dialog box, enter a Name and Description for the iteration, and then click Confirm.
  • Operation History: Click Operation History in the upper-right corner of the page to view the operation time, operator, and operation logs for the iteration.
  • Close Iteration: Click Disable Iteration in the upper-right corner of the page, and then click Confirm in the dialog box that appears.
    Important After an iteration is closed, you can use the Create As feature, but you cannot reopen the iteration. Proceed with caution.
• Modify or view basic information about the iteration.
  • Iteration name: Click the icon next to the iteration name to modify it.
  • Iteration description: Click the icon next to Iteration Description
  • Project: Click the project name next to Project to view the project details.
  • Participants: Click the icon next to Participants
  • Available databases: Click View next to Available Databases to edit the available databases for the iteration.
    • Add an available database: In the Available Databases list, select the database that you want to add and click the icon. The database is then displayed in the Available Databases list.
    • Remove an available database: In the Available Databases list, select the database that you want to remove and click the icon. The database is then removed from the Available Databases list.
  • Iteration template: Click the template name next to Iteration Template to view the template details.