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
- 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 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
- 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.