Upgrading the databases on SQL Server

If you are using 

version 8.1 or any of the 8.1 Service Packs, before running ETL, you must run an upgrade script for each 8.1 and 8.1 SP site in your  installation.

• CDC tables for assets
• To upgrade the databases

If this is a fresh installation, you only have one database set up (the primary site). If this is an upgrade, you might have multiple databases in your environment.

CDC tables for assets

The database upgrade script ensures the successful transfer of incremental data for asset information from the 

database to the data warehouse in the 3_CONFIG_OBJECTS scenario, as follows.

Whenever a new entry is added to a Config Object table in the BMC Server Automation database, a trigger inserts the entry into the corresponding Config Object Dimension CDC table. The ETL process references the CDC tables for entries and only the entries that are added after the last ETL run (incremental entries) are loaded in the reports data warehouse. The CDC tables are added for the following assets:

• File System
• Complus
• Configuration
• .NET Assemblies
• Event Logs
• Custom objects (Hardware Information, UNIX Users, UNIX Groups, UNIX Processes, UNIX Daemon Listener)
• Security Settings
• Local Groups
• Local Users
• Registry
• Services
• Applications/HotFixes
• Packages
• Patches
• RPMs

To upgrade the databases

1. Navigate to the directory that contains the upgrade scripts.
    These are the scripts that you extracted from the BDSSA82-servicepackVersion-external-files.zip file, which are located in the /BDSSA/Db_Scripts/sqlserver/schema directory by default. For more information about the zip file, see Downloading-the-BMC-BladeLogic-Decision-Support-for-Server-Automation-External-Files.
2. Log on to the Microsoft SQL Server database as bladelogic(or the name you chose for the 

   The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

   user).

3. Run the following script (this is the same for char and nchar):

   sqlcmd -U <BSAUser> -d <database> -P <BSApassword> -S <server> -o <logFile> -i
   OM_upgrade_for_BDSSA_8.2.0_sqlserver.sql

   where

   • <BSAUser> and <BSApassword> are the user name and password for logging on to the 

     The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

     database you are upgrading.
   • <database> is the database you are upgrading.
   • <server> is the server on which the database resides.
   • <logFile> is the log file to which script results are sent.
   • <Release> is the number of the release to which you are upgrading.
     When the script completes, the database is upgraded. Repeat this procedure for each 

     The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

     database.

After completing this procedure, run ETL.