Applies to version: 2021.x.x.xxx and above; author: Mateusz Syrek

Introduction

This article describes 3 variants for transferring WEBCON BPS databases to a different SQL server:

1. new server has the same name as the old one,
2. new server has a different name – applying SQL aliases,
3. new server has a different name – no SQL aliases applied, changing configuration.

Each variant consists in transferring data bases by creating backups, transferring them to a new server, and their recreation on a new SQL instance.

Before you start, stop WEBCON BPS app in the Internet Information Services (IIS) and WEBCON WorkFlow Service.

1. New server has the same name as the old one

The operations to be performed here are creating a backup and recreating databases on a new server. Finally, run the app in IIS and the WEBCON WorkFlow Service.

2. New server has a different name – applying SQL aliases

Similarly, create a data base backup and recreate them on a new server.

Add alias on an old server. One way is to use SQL Server Client Network Utility – cliconfg.exe

The configuration should be performed for 32-bit or 64-bit system version. Depending on the version, the tool is available at:

• 32-bit system: "C:WindowsSystem32cliconfg.exe"
• 64-bit system: "C:WindowsSysWOW64cliconfg.exe"

After running cliconfg.exe, open the ”Alias” tab. Press the ”Add” button and add a new alias.

In the displayed window enter the right configuration for:

1. protocol,
2. alias name,
3. new server name,
4. new server port – uncheck the checkbox and fill-out if other than the default one.

A configured alias appears once you click “OK”.

Finally, run the app in IIS and the WEBCON WorkFlow Service.

3. New server has a different name – no SQL aliases applied, changing configuration

Similarly to the first case, create a data base backup and recreate them on a new server. Now, run the WEBCON BPS installer and change the service configuration in ”Tools for application management” by setting up a new server in the database connection settings.

Press “Save” to keep the changes.

Now, set up a new server name in the portal configuration file “appsettings.user.json”. Its default location is ”C:Program Files (x86)WEBCONWEBCON BPS Portalappsettings.user.json”.

Run the app in the IIS and the WEBCON WorkFlow Service.

Finally, check all the data sources, integrations etc. and change their configuration if needed.