Upgrading an existing Microsoft SQL Server database

Follow the steps to upgrade the version 11.5 InfoSphere® MDM database to the version 11.6 InfoSphere MDM database for Microsoft SQL Server.

Before you begin

For information about upgrading the database for previous releases, see the links at the end of this topic.

Read the content for the link at the end of this topic about manual installation of the database.

Run the following command from the command line: sqlcmd -S <server Name> -U sa -P sapassword -i inputquery_file_name -o outputfile_name

Procedure

  1. Navigate to the MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/SQLServer/Standard/ddl/ directory and run the CreateIndexes.sql upgrade script.
  2. Replace the placeholder <SCHEMA> in the scripts in the following folders with a schema name or owner. Ensure that the name or owner is in uppercase. CODE_LANG in the folder name is the language that is currently installed.
    Note: If any of the directories are empty, no data was generated and you do not need to run the scripts.
    • MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/SQLServer/Standard/ddl/data_req_CODE_LANG/data
    • MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/SQLServer/Standard/ddl/data_CODE_LANG/data-industry
    • MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/SQLServer/Standard/ddl/data_opt_CODE_LANG/data
  3. To load the common data, to load the English code table data, and to configure the table in the language that you selected, run the following script in the MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/SQLServer/Standard/ddl/data_req_CODE_LANG/data directory from the command line. Use the command: sqlcmd -S <server Name> -U sa -P sapassword -i inputquery_file_name -o outputfile_name
    1. The insert.sql script inserts new data.
    2. The update.sql script updates existing table data.
    3. The delete.sql script deletes obsolete table data.
    If you are loading English data only, set CODE_LANG to en. Otherwise, set CODE_LANG to the language code of the language you are loading.
  4. To load the English industry data, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/SQLServer/Standard/ddl/data_en/data-industry directory from the command line. Use the command: sqlcmd -S <server Name> -U sa -P sapassword -i inputquery_file_name -o outputfile_name
    1. The insert.sql script inserts new data.
    2. The update.sql script updates existing table data.
    3. The delete.sql script deletes obsolete table data.
  5. If you are loading data for a language other than English, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/SQLServer/Standard/ddl/data_<CODE_LANG>/data-industry directory from the command line. Use the command: sqlcmd -S <server Name> -U sa -P sapassword -i inputquery_file_name -o outputfile_name
    1. The insert.sql script inserts new data.
    2. The update.sql script updates existing table data.
    3. The delete.sql script deletes obsolete table data.
  6. If you are loading code table data for a language other than English, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/SQLServer/Standard/ddl/data_opt_CODE_LANG/data directory from the command line: sqlcmd -S <server Name> -U sa -P sapassword -i inputquery_file_name -o outputfile_name
    • The insert.sql script inserts new data.
    • The update.sql script updates existing table data.
    • The delete.sql script deletes obsolete table data.
  7. Repeat the previous two steps for each non-English language that is installed.
  8. Navigate to the MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/SQLServer/Standard/ddl/ directory.
  9. Run the following command: ImpReqDataCfgMgr.bat
  10. Run the following command: sqlcmd -S <server Name> -U sa -P sapassword -i QryUpdCfgMgrData.sql -o QryUpdCfgMgrData.log
    The QryUpdCfgMgrData.sql script populates the Configuration Manager values based on previous deployment values.