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 current database is using a SQL Server 2014 instance, then you must select SQL Server 2014 or newer for the replacement instance. You may not select an older instance, such as SQL Server 2012.

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

The PDXpert service assumes 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 create 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 the Manage tab.

  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 the server's Information tab.

3003

Learn More
Help Guide Contents [PDF]