The environment type you assign to an instance determines the default approval and access-control rules that DMS applies to it. Assigning the wrong type can silently downgrade security controls on a production database or add unnecessary approval overhead to a development database.
Environment types
DMS supports eight environment types in two categories: offline and online.
| Category | Environment type | Environment ID |
|---|---|---|
| Offline | Development | dev |
| Offline | Test | test |
| Offline | SIT | sit |
| Offline | UAT | uat |
| Offline | Stress testing | pet |
| Offline | STAG | stag |
| Online | Production | product |
| Online | Staging | pre |
In the Security Collaboration mode, the test environment requires no approval and has lighter controls by default, while the production environment enforces strict controls by default. To change these defaults, see Change the control mode of an instance.
Change the environment type
Prerequisites
Before you begin, make sure you have:
A database instance registered in DMS
Permissions to edit instance settings
Procedure
Log on to the DMS console V5.0.
In the top navigation bar, choose Data Assets > Instances.
NoteTip: Alternatively, find the instance in the left-side navigation pane on the Home page, right-click it, and select Edit.
On the Instance List tab, find the target instance and choose More > Edit in the Actions column.
In the Edit dialog box, click Advanced Information.
Select the appropriate environment type from the Environment type drop-down list.
Click Save.
What's next
To change how DMS governs operations on this instance, see Change the control mode of an instance.