Space banner This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

Upgrading your SQL Server database

Upgrading your SQL Server database

If you upgrade from version 10.1 or later, an automatic update is proposed with the master upgrade. There are, however, situations in which you still must manually upgrade the tablespaces before launching the master upgrade.

Updating the SQL Server tablespaces for version 10.1 and later

If you are upgrading from version 10.1 or earlier to the current version you first need to upgrade your database to version 11 and then to 12 by executing the following scripts: first support\database\sqlserver\dbtablespaces_1010_1100.sqlserver.sql and then support\database\sqlserver\dbtablespaces_1170_1200.sqlserver.sql of the downloaded archive. Proceed as follows:

  1. Open the SQL Query Analyzer and select the device on which the BCM database is located (for example, local , if it is on the local device).
  2. Open the file support/database/sqlserver/dbtablespaces_1010_1100.sqlserver.sql of the downloaded archive in the SQL Query Analyzer window.
  3. In the script replace the placeholder &2 with the name of the BCM database (for example, bcmdb ), and &1 with the path to the tablespaces subdirectory (for example, Microsoft SQL Server/MSSQL/Data/ bcmdb ).
  4. Verify that the script works correctly by clicking Parse Query . If this is the case execute the script by clicking Execute Query .
  5. Then open the file support/database/sqlserver/dbtablespaces_1170_1200.sqlserver.sql of the downloaded archive in the SQL Query Analyzer window.
  6. In the script you need to replace again the placeholder &2 with the name of the BCM database and &1 with the path to the tablespaces subdirectory.
  7. Verify that the script works correctly by clicking Parse Query . If this is the case execute the script by clicking Execute Query .

The tablespaces are now upgraded and you can continue with the master server upgrade.

Upgrading the SQL Server tablespaces for version 11.1 and later

If you are upgrading your master from version 11.1 or later to the current version you need to upgrade your database by executing the following script: support\database\sqlserver\dbtablespaces_1170_1200.sqlserver.sql of the downloaded archive. Proceed as follows:

  1. Open the SQL Query Analyzer and select the device on which the BCM database is located (for example, local , if it is on the local device).
  2. Open the file support/database/sqlserver/dbtablespaces_1170_1200.sqlserver.sql of the downloaded archive in the SQL Query Analyzer window.
  3. In the script replace the placeholder &2 with the name of the BCM database (for example, bcmdb ), and &1 with the path to the tablespaces subdirectory (for example, Microsoft SQL Server/MSSQL/Data/ bcmdb ).
  4. Verify that the script works correctly by clicking Parse Query . If this is the case execute the script by clicking Execute Query .

The new tablespaces are now created and you can continue with the master server upgrade.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*