versago:update_database_connection
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
versago:update_database_connection [2020/02/03 08:26] runger created |
versago:update_database_connection [2020/09/08 09:16] (current) dlee |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| </ | </ | ||
| - | ====Identify the connection(s) to be changed==== | + | ====Identify the Connection(s) to be Changed==== |
| - | Database connection information is found in the **TWBS_WS_OCMP** table in the __Versago Common database__ | + | 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. |
| + | |||
| + | <code sql> | ||
| + | select * from TWBS_WS_OCMP | ||
| + | </ | ||
| + | |||
| + | The key fields needed to make this change are: | ||
| + | |||
| + | * ID | ||
| + | * ServerName | ||
| + | * DBName | ||
| + | |||
| + | ====Change the Connection Information==== | ||
| + | |||
| + | <WRAP center round important 80%> | ||
| + | **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** | ||
| + | <code sql> | ||
| + | update TWBS_WS_OCMP | ||
| + | set ServerName = < | ||
| + | where ID = < | ||
| + | </ | ||
| + | |||
| + | **Update the Target Database** | ||
| + | <code sql> | ||
| + | update TWBS_WS_OCMP | ||
| + | set DBName= < | ||
| + | where ID = < | ||
| + | </ | ||
| + | |||
| + | **Update Both the Target Server and Database** | ||
| + | <code sql> | ||
| + | update TWBS_WS_OCMP | ||
| + | set ServerName = < | ||
| + | where ID = < | ||
| + | </ | ||
| + | |||
| + | ====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.1580736390.txt.gz · Last modified: 2020/02/03 08:26 by runger
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
