In some cases, it can be required that you copy a database to another environment. For example, you have a test environment and a production environment. An issue occurs in the production environment. So, testing is required to find the cause of the issue. However, you do not want to mess up the production environment with testing data. You can copy the full production database to the test environment.
If you copy a database to another environment, the Connectivity studio parameters are overwritten with the parameter settings of the copied database. However, usually, you want to keep the original and unique parameter settings for an environment.
You have two options to make sure the Connectivity studio parameters are unique for the environment:
Before copying the database to an environment, export the Connectivity studio parameters from that environment. And after copying the database, import the parameters back to the environment.
After copying the database to an environment, delete the Connectivity studio parameters and set the parameters again. A disadvantage of this approach is that a new environment ID is generated. With a new environment ID, it is difficult to get back checked-out projects because these are checked out by another environment ID.
Prerequisites:
Before you copy a database:
From an environment, for example the production environment, make sure that all version-managed projects are checked in or get latest is done.
To an environment, for example the test environment, make sure that:
All version-managed projects are checked in.
The non-version-managed projects that you want to keep are exported. After copying the database, you can import these projects back into the environment.