Documentation Center

What to do when the database is moved

This topic lists the actions that need to be taken when a database is moved to another server or if the database is renamed.

Procedure

  1. Ensure no one is using the database:
    1. On the Content Manager (main) server, open IIS Manager and stop the website under which Content Manager is running.
    2. On all servers, open Component Services and stop the COM+ components.
    3. Stop all our services on all servers where they are running. Stop Crawlers, TranslationOrganizers, TranslationBuilders and BackgroundTask services.
  2. Make a backup of the database and restore it to the new database location.
  3. On all servers, open Registry Editor and change the connect string and the database type in the following entries:
    1. HKLM\SOFTWARE\Wow6432Node\Trisoft\Tridk\TridkApp\InfoShareAuthor[projectsuffix]\Connect
    2. HKLM\SOFTWARE\Wow6432Node\Trisoft\Tridk\TridkApp\InfoShareBuilders[projectsuffix]\Connect
  4. Update the copy of the inputparameters.xml file for the current installation:
    1. In the Windows Registry, locate the entries with the install history of the current installation. These are located in the keys:
      • HKLM\SOFTWARE\Wow6432Node\Trisoft\InstallTool\InfoShare\Core\History
      • HKLM\SOFTWARE\Wow6432Node\Trisoft\InstallTool\InfoShare\InfoShare\History
      The current entries are the most recent ones with a name ending in =Install. Within these keys, the entry InstallHistoryPath refers to the folder with the installation parameters files.
    2. From the folders specified in the previous step, open the InputParameters.xml file and (if necessary) update the current value for the following parameters to reflect the new database:
      • connectstring
      • databasename
      • databasesource
      • databaseuser
      • databasepassword
      • databaseserverversion
    3. If the database name has changed, open the file, ISH_CreateStandardInfoShareJob.sql and update the database name on line 3. Depending on the type of database, the location of the file is:
      • Oracle:

        drive:\InfoShare\Appprojectsuffix\Database\Common\Oracle

      • SQLServer2012:

        drive:\InfoShare\Appprojectsuffix\Database\Common\SQLServer2012

      • SQLServer2014:

        drive:\InfoShare\Appprojectsuffix\Database\Common\SQLServer2014

    4. Run the database upgrade tool.

What to do next

Perform basic testing by creating a folder and deleting it. Perform a search and do a publish action.