versago:update_database_connection
This is an old revision of the document!
Table of Contents
Changing A Database Connection Record
Before you begin:
This process requires access to the SQL Server Management Studio application and a knowledge of T-SQL commands. Contact Third Wave support at https://portal.twbs.com if you are not comfortable with the following instructions.
Identify the Connection(s) to be Changed
Database connection information is found in the TWBS_WS_OCMP table in the Versago Common database. Use the following query to list the existing connections.
SELECT * FROM TWBS_WS_OCMP
The key fields needed to make this change are:
- ID
- ServerName
- DBName
Change the Connection Information
Caution The following commands will modify data in your database.
- Determine the ID of the connection to be changed.
- Note the existing ServerName and DBName values.
- Be sure you have the new value(s) for ServerName and/or DBName.
- Use the query shown below to update the record.
Update the Target Server
UPDATE TWBS_WS_OCMP SET ServerName = <NewName> WHERE ID = <AppropriateID>
Update the Target Database
UPDATE TWBS_WS_OCMP SET DBName= <NewName> WHERE ID = <AppropriateID>
Update Both the Target Server and Database
UPDATE TWBS_WS_OCMP SET ServerName = <NewName>, DBName= <NewName> WHERE ID = <AppropriateID>
Check the Change
- Open the Versago Admin page.
- Open the Settings > Databases page
- Confirm that the values are displayed correctly.
- Execute a report that uses the changed connection and confirm that the information returned is correct.
versago/update_database_connection.1580737320.txt.gz · Last modified: 2020/02/03 08:42 by runger
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
