Applies to version: 2021.x.x.xxx and above; author: Mateusz Syrek
This article describes 3 variants for transferring WEBCON BPS databases to a different SQL server:
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.
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.
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:
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:
A configured alias appears once you click “OK”.
Finally, run the app in IIS and the WEBCON WorkFlow Service.
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.