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.


Application Consultant Application Consultant Export Connectivity studio parameters Export Connectivity studio parameters If you want to copy a database to the current environment and you want to keep the Connectivity studio parameters, first export these parameters. As a result, an XML file with the parameter settings is created and downloaded to your local downloads folder. Procedure 1. Click Connectivity studio Integration Design. 2. Click Connectivity studio parameters. 3. On the General tab, click Export. 4. In the Download file field, you can change the default XML file name as desired. 5. Select Yes in the Run in background field. 6. Click OK. 7. Close the page. Start Start Import Connectivity studio parameters Import Connectivity studio parameters If you have copied a database to the current environment and you first exported the Connectivity studio parameters, you can import these parameters. As a result, the Connectivity studio parameters are automatically reset with the original environment parameters. Procedure 1. Click Connectivity studio Integration Design. 2. Click Connectivity studio parameters. 3. Click Import. 4. Click Select configuration to browse for and select the parameters XML file to be imported. 5. Select or clear the Run in background check box. 6. Click OK. 7. Close the page. Database is copied to  current environment Database is copied to  current environment End End Keep or reset  parameters? Keep or reset  parameters? Database is copied to  current environment Database is copied to  current environment Delete Connectivity studio parameters Delete Connectivity studio parameters If you have copied a database to the current environment and you want to manually reset the Connectivity studio parameters, first delete these parameters. As a result, all parameter settings are deleted, and a new environment ID is generated. If the imported parameters are fine, you can also decide to only reset the Environment ID. As a result, only these fields are reset: Environment ID: A new ID is generated for the environment. Environment type: The environment type is reset to None. Description: The description is reset to name of the current environment. Procedure 1. Click Connectivity studio Integration Design. 2. Click Connectivity studio parameters. 3. Sub-task: Delete parameters. 4. Click Delete. 5. Select the desired option: Yes or No. 6. Sub-task: Reset environment identification. 7. Click Reset Identity. 8. Close the page. Set Connectivity studio parameters

Set Connectivity studio parameters

Before you start using Connectivity studio, set up the Connectivity studio parameters.

Keep Reset

Activities

Name Responsible Description

Export Connectivity studio parameters

Application Consultant

If you want to copy a database to the current environment and you want to keep the Connectivity studio parameters, first export these parameters.

As a result, an XML file with the parameter settings is created and downloaded to your local downloads folder.

Import Connectivity studio parameters

Application Consultant

If you have copied a database to the current environment and you first exported the Connectivity studio parameters, you can import these parameters.

As a result, the Connectivity studio parameters are automatically reset with the original environment parameters.

Delete Connectivity studio parameters

Application Consultant

If you have copied a database to the current environment and you want to manually reset the Connectivity studio parameters, first delete these parameters. As a result, all parameter settings are deleted, and a new environment ID is generated.
If the imported parameters are fine, you can also decide to only reset the Environment ID. As a result, only these fields are reset:
  • Environment ID: A new ID is generated for the environment.
  • Environment type: The environment type is reset to None.
  • Description: The description is reset to name of the current environment.

Set Connectivity studio parameters

Application Consultant

Before you start using Connectivity studio, set up the Connectivity studio parameters.

See also

Provide feedback