Change the database server

By default, the PDXpert Application Server installs its own Microsoft SQL Server database instance. If you wish, you can specify a different SQL Server instance.

Back up your database before changing the SQL Server instance.

The SQL Server instance you select must be compatible with your existing SQL Server database files. For example, if your database is using a SQL Server 2019 instance, then you must select SQL Server 2019 or newer for the replacement instance. You may not select an older instance, such as SQL Server 2017.

The selected SQL Server instance must exist on the current computer. Do not select a SQL Server instance on a different computer.

The PDXpert service expects it has full control of the instance, which may occasionally include restarting it. This can affect other applications that share the same instance.

Do not make new objects within the PDXpertDB database, since unrecognized objects may interfere with proper operation or be deleted.

All users must be logged out of the PDXpert client application.

On the PDXpert Application Server window:

  1. Click on Manage.

  2. In the System changes area, click on the Change Database Server... button to open the SQL Server Selector dialog.

  3. Select or enter a Database engine (instance) name, and click the OK button to save your selection. The connection uses the form .\instancename, like .\PDXPERT.

    This change simply specifies which SQL Server instance manages your database. The database files and library files remain in exactly the same data directory.

    When you need technical support for your system, include details about your database instance as shown on Information.

Downgrading the database server§

This procedure deletes your database and library files. Before using this procedure, back up the database and the library files.

Downgrading does not convert a higher-level SQL Server database to the lower-level SQL Server version. The database that you restore in the last step must be compatible with the lower-level SQL Server engine.

If you must change to a lower-version SQL Server (for example, because an incorrect SQL Server instance was selected above):

  1. Back up both database and library. See the Reset the database and library help topic.

  2. In the System changes area, click on the Change Database Server... button to open the SQL Server Selector dialog.

  3. Select or enter the original SQL Server instance, and click the OK button to save your selection.

    You can ignore an error message about the empty database being incompatible or cannot be mounted.

  4. Reset the database again. This loads a starting database that is compatible with the selected SQL Server version, and verifies the database connection.

  5. Restore the database and the library files. See the Restore data from a backup help topic.

3003

Help Guide Contents [as PDF]