Changing WEBCON BPS database name

Author: Paweł Drab

Introduction

Migration of databases to a different database environment or their recreation in such environment may require changing database name. If references to a database are present in several locations, external, logical change of database name is insufficient. The article describes the procedure of changing database name by modifying configuration.

Procedure

The procedure involves:

1. changing all locations in the configuration where database name (except ID and acronym) appears,
2. changing service configuration,
3. changing portal configuration,
4. changing queries in:

• data sources,
• actions,
• business rules (SQL COMMAND),

in locations where it is not possible to choose the <current database> option or where the query contains direct reference to the database.

If the problem applies to a newly installed WEBCON BPS app, it is better to reinstall the app than to enter the changes manually.

Changes in configuration entries

Configuration database

• content.GlobalParameters, "ConfigDatabase" parameter
• WEBCON/WEBCON BPS Portal/appsettings.user.json
• ConfigConnection.Initial Catalog
• LogsConnection.Initial Catalog

Content database

• content.ContentDatabases.CD_Name
• attachmentDB.GlobalParameters, parametr "DBMain"
• archiveDB.GlobalParameters, parametr "DBMain"
• installation of SP – WEBCON BPS Feature on SP websites

Attachment database

• content.GlobalParameters, "WFAttachmentsDefaultDB" parameter
• content.WFAttachmentDatabases.ADB_Name
• content.WFDefinitions.DEF_AttachmentsDatabase

Archive database

• content.GlobalParameters, parametr "ArchiveDefaultDB"
• content.ArchivingDatabases.ARD_Databases
• content.WFDefinitions.DEF_ArchivingDatabase

SQL queries for checking database list

1  | -- CONFIG
2  | select CD_ID, CD_Name, CD_Type from ContentDatabases
3  |
4  | -- CONTENT
5  | select ARD_ID, ARD_Name from ArchivingDatabases
6  |
7  | select ADB_ID, ADB_Name from WFAttachmentDatabases
8  | 
9  | select DEF_ID, DEF_Name, DEF_APPID, DEF_AttachmentsDatabase, DEF_ArchivingDatabase from WFDefinitions
10 | 
11 | select PRM_Name, PRM_Value from GlobalParameters
12 | where PRM_Name in ('WFAttachmentsDefaultDB', 'ConfigDatabase', 'ArchiveDefaultDB')
13 |
14 | -- ARCH/ATT
15 | select PRM_Name, PRM_Value from GlobalParameters
16 | where PRM_Name in ('DBMain')