What to do when the database is moved

These actions 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 (of a SQL Server database) has changed, go to the folder matching the SQL Server version, search for the statement set @DatabaseName in all files (and sub folders) and replace in all files the old database name with the new database name.
      • For SQL Server 2016 the path is:

        drive:\InfoShare\Appprojectsuffix\Database\Common\SQLServer2016

      • For SQL Server 2017 the path is:

        drive:\InfoShare\Appprojectsuffix\Database\Common\SQLServer2017

    4. Run the upgrade command of DBUpgradeTool.

What to do next

Perform a basic test by creating a folder and deleting it. Perform a search and a publish.