These actions need to be taken when a database is moved to another server or if the database is renamed.
Procedure
- Ensure no one is using the database:
- On the Content Manager (main) server, open IIS Manager and stop the website under which Content Manager is running.
- On all servers, open Component Services and stop the COM+ components.
- Stop all our services on all servers where they are running. Stop Crawlers, TranslationOrganizers, TranslationBuilders and BackgroundTask services.
- Make a backup of the database and restore it to the new database location.
- On all servers, open Registry Editor and change the connect string and the database type in the following entries:
- HKLM\SOFTWARE\Wow6432Node\Trisoft\Tridk\TridkApp\InfoShareAuthor[projectsuffix]\Connect
- HKLM\SOFTWARE\Wow6432Node\Trisoft\Tridk\TridkApp\InfoShareBuilders[projectsuffix]\Connect
- Update the copy of the
inputparameters.xml file for the current installation:
- 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.
- 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
- 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.
- 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.