Database

This section shows how to install a PPR database.

Deployment readiness checklist

You can install the PPR database on a supported Microsoft SQL Server that runs on any of the following operating systems:

Before you begin, make sure that the following applications are installed on the server:

Installing the database

  1. Obtain the Database installer.

  2. Run the DatabaseInstall.exe file as an administrator.

  3. Read and accept the End-User License Agreement (EULA), and then click Install.

  4. Provide the fully qualified domain name (FQDN) or IP address of the SQL database server.

    Note: If the database is running on a non-default instance name and non-default port, then provide the instance name.

  5. Provide the database server login ID and password.

  6. If the installer detects a previously installed AVPUBLISH database, do either of the following:

    • To overwrite the database, select Replace Database check box, and then click Next.

    • If you do not want to replace the existing database, then click Next.

  7. Browse to the folder where you want to save the database files.

    Note: We recommend keeping the default directory.

  8. Install the database.

Notes:

Make sure that the database is installed successfully.

The AVPUBLISH database must be available when you view it from the SQL Server Management Studio.

Upgrading the database

If you want to upgrade the database instead of installing the later version, see the following section.

Note: For example, to upgrade to PPR Database 10.5, make sure that the existing database version is 10.4. If the database version is earlier than 10.4, then upgrade it manually by running the SQL files in the Upgrade Script folder in the following order:

  1. From the database installer package, extract the UpgradeScripts.zip file.

  2. From the UpgradeScripts/10.4_10.5/WSData/SQTs folder, validate each SQT file.

  3. If any customization is required, then update the SQT files manually.

  4. Merge the updated files with the existing SQT files.

  5. From the UpgradeScripts/10.4_10.5 folder, do the following:

    SQL Server 2016 or later (supports compatibility level 130 or above)

    1. Open the upgrade_130.bat file.

    2. If necessary, edit the database and server names.

      Notes:

      • The default database name is <AVPUBLISH>.
      • The default server name is <.>.

    3. At the command prompt, navigate to the UpgradeScripts/10.4_10.5 folder.

    4. Run the command upgrade_130.

    SQL Server 2014 or earlier (does not support compatibility level 130 or above)

    1. Open the upgrade_80.bat file.

    2. If necessary, edit the Database and Server names.

      Notes:

      • Default Database name = <AVPUBLISH>
      • Default Server name =<.>

    3. At the command prompt, navigate to the UpgradeScripts/10.4_10.5 folder.

    4. Run the upgrade_80 command.

    Notes:

    • For SQL Server 2014 or earlier, you must update the CMSContent and CMSPage tables manually.
    • For more information, see the CMSUpgradeGuide.txt file in the UpgradeScripts\10.4_10.5 folder.

Verifying a successful upgrade

After you upgrade the database, the installed database version appears as the previous version only (version 10.4 in this scenario).

To confirm if you have successfully upgraded the database, do the following:

  1. Go to Microsoft SQL Server Management Studio.

  2. Run the query Select * From DbSchemaVersion.

If the upgrade is successful, then one row of the DbSchemaVersion table shows the following information: