Managing a PDXpert test server

Last update 2020-06-24


You may want to copy PDXpert production data to a different computer for report development, import testing, upgrade verification, user training, or other non-production purpose.

In this topic, the source computer contains an existing database and library files that is copied to the target (or TEST) computer.

The source and target systems cannot contain duplicate software license keys or database unique identifiers. The target system must be adjusted before it can be used alongside the production system.

  • Your PDXpert software license agreement requires a separate license key for each PDXpert server. The source and target servers must use different license keys.

  • PDXpert client applications use the database unique identifier (DatabaseId) to cache data for each database separately.

    When more than one system shares the same DatabaseId, the PDXpert client cache may be corrupted when switching between the two systems. This can damage the production database or cause client connection errors.

Moving a production backup into a test system§

All PDXpert clients must be logged out of the target system before you begin.

Do not allow PDXpert clients to use the target (TEST) system until these steps are done.

To configure the target system:

  1. Obtain a TEST server license key for the target server.

    The TEST system license can be used only for test, training and development purposes. It cannot be used for a second production system. It can be imported into, or used with, one TEST system.

    One TEST key is available on request if you have a license with a current maintenance subscription. The TEST key expires at the end of the subscription period, and must be renewed.

  2. Copy the production database and library to the target server as described in Moving your PDXpert PLM database and file library. Do not perform the final Uninstalling the source server section.

    If you use the TEST system only for database activities, you may skip copying the library files. For example, physical files are not needed for report development, user role & change workflow tests, and bulk import/update tests. However, some functions may not work, such as (obviously) viewing/copying files, exporting PDX packages, and bulk updates to file attachments. If you're not sure, contact Technical Support.

  3. If you use PDXpert 13.0 or later, you can skip this step. If you're using PDXpert 12.2 or earlier, you must update the TEST system's DatabaseId so each client uses a separate cache for the source and target systems.

    1. Using SQL Server Management Studio, Powershell or other tool, run this SQL query:

      UPDATE dbo.PDXpertInfo SET DatabaseId=newid();

    2. Restart the TEST server machine, or use the Windows Control panel to restart the PDXpert Server service.

  4. As an administrator, open a PDXpert client:

    The TEST system normally contains the same user accounts and passwords as the production system. If the test license allows fewer user accounts than the production system, you must log in using the super administrator's account, which may require you to reset the administrator password.

  5. If you don't want the TEST system to send email notices from the production email account, edit the account information:

    1. Select Tools menu → Email Management... command.

    2. On the Email Management window, do one of the following:

      • Enable the TEST system email account by setting the account, SMTP server, etc.
      • Disable all emails: in the Outgoing mail server (SMTP) textbox, enter an invalid SMTP address, like:
    3. Click the Apply Changes button.

    4. Close the Email Management... window.

  6. At your option, set the TEST system's color code.

  7. To confirm that the production server and test server have the correct software license and different DatabaseId, add and then run the following data transformation to both the source and target systems.

    This step only needs to be done once: when you move the source database again, the target database will contain the source system's transform.

Each server is responsible for managing and updating its own localhost client. Do not connect one server's localhost client to the other server. Do not install another PDXpert client on the TEST server. Remote clients — that is, clients that connect to a named server rather than to localhost — can freely connect to either server, which can be different releases.

Before installing a new PDXpert release or SQL Server upgrade on the production system, you can upgrade the TEST system to verify correct operation. In most other cases, use the same PDXpert release and SQL Server version on both TEST and production systems.

Consider taking a backup now. Restore this backup when you wish to return to the starting test configuration, without repeating the steps above.


Install Guide Contents