6. Creating a Test Environment

6.1. Backup and restore

1. Create a backup from the company database/schema.

2. Restore the test database/schema with the backup created from the live database/schema and the test PMX database/schema with the backup created from the PMX live database/schema.

  • When restoring a database in MSSQL, make sure that you change the database/schema file names on the Files page as well.
  • For more information about schema export, import and migration on HANA click here.

If you backup and restore the company database/schema only, customizations added in the PMX stored procedures will not be copied to the test environment.

6.2. Upgrade database

1. Start the Produmex Suite Installer.

2. Click the green + icon to add a new connection.

3. Set the environment to Test.

4. Specify the connection string in the Alias column.

5. Add the name of the company database.

6. Enter the SAP user name and password.

7. Test the SBO connection and the Direct connection.

Produmex Suite Installer

8. Go to the tab of the database/schema server and change the Target environment to Test.

Components are installed in separate subfolders marked as Test when executing the installation in the Test environment.

9. Adjust the Directory path if needed.

10. Click the Assign to this computer button to mark that this is the server you are currently working on.

11. Install Produmex components and run the database/schema upgrade. Make sure that you select the right connection string.

Note: You cannot install a test Produmex License server. Before clicking the Install all button, make sure that you disable the Produmex License Server.

Produmex Suite Installer

If there is an installed PMX version in the test environment and you don’t need an upgrade, you can adjust the connection string in the configuration files by clicking the Update connection string button. For more information click here.

6.3. Adjust company settings

1. Run the Produmex add-on and open the Organizational Structure. On the General tab adjust the following if needed:

  • username
  • password
  • license server

2. On the Config tab adjust the EDI folder paths to make sure that test documents are not mixed with documents created for the live database/schema. The following paths needs to be adjusted:

  • Interface monitor input archive path
  • Interface monitor input error path
  • Interface monitor input path
  • Interface monitor output archive path
  • Interface monitor output error path
  • Interface monitor output path
Admin Detach Close

This topic does not exist yet

You've followed a link to a topic that doesn't exist yet. If permissions allow, you may create it by clicking on Create this page.