Product(s):		Promis.e CONNECT Edition
	Version(s):		10.00.XX.XX to 10.12.XX.XX
	Environment:		NA
	Area:		Database Platform Support
	Subarea:		NA

Background:

Organizations usually have IT Policy in place that might need regular upgrading/changing Servers on regular intervals or according to the policies. in the article will help Database Admin/It Admins on impacts of changing of Serves for Promis.e Projects whose Project Database is located on Network location for multiple users to access. 

Methods of Changing the Server

1. Restoring Project from Backups to new SQL Database Servers.

2. Backup and Restoring database backup from old server to new Server. 

1. Restoring Project from Backups to new SQL Database Servers.

This methods is usually recommended for the users who have maintain latest Backups of all the projects. And they are planning to change the File Server as well where the projects are stored. This method will be helpful as the user can configure to the new Servers and then just Restore the Backup's of Projects and start working. Due to this process the database is also cleaned as only required data associated to project is restored in the new Database. 

In case if the user decide to use this method but dont have backup of all the projects, then they can use the Auto-Backup feature which can run on a remote machine which will create project backups. Below is a Wiki Link for the steps for using AutoBackup command in Promis.e CONNECT. 

Steps to Follow

1. First Determine the SQL Server that you are planning to use with Promis.e CONNECT. Then Create a New Project Database on the Server for Promis.e CONNECT using the steps in the below Wiki Link. 

2. Then configure the new Database in Promis.e CE if not done already from Configure Database under Admin Tools >> Select/Specify Server name, database name and Authentication and Click OK. 

Important Note: The database configuration for default database is a per user settings and admins can deploy the file "DBSettings.xml" located in "C:\ProgramData\Bentley\Promise CONNECT Edition\Configuration\Datasets\Promise\Config" to user machine after following the above steps. 




3. Restore the Project using the Project Backup and select the new Database for Restoring the Project. Refer the below Wiki Link for Steps to Restore Project. 
Note: If the file server is not changed and if restoring the project to the same location as original project, then either delete the old project or restore the project with modified name according to requirement. 

 

2. Backup and Restoring Database backup from old server to new Server location. 

This method is recommended to the users who have large number of Projects or in the scenario where the user is only changing the SQL Database  Server. 

Points to Consider: 

1. Check the compatibility of the SQL Server with Promis.e CONNECT version using the below Compatibility Chart to sure that compatible SQL Server is being used. 

2.  The Details related to Server Name and Database name is stored inside each project folder inside ECT.FID file which is used by Promis.e CONNECT to establish connection with the Project. Hence if there is a Server Name and or Database Name change for the new Server location then it needs to be updated in all the projects ECT.FID file. 

Steps to Follow 

1. Backup the Database from the old SQL Server. 

2. Restore the Database on New SQL Server. 

3.  Then configure the new Database in Promis.e CE if not done already from Configure Database under Admin Tools >> Select/Specify Server name, database name and Authentication and Click OK. 

Important Note: The database configuration for default database is a per user settings and admins can deploy the file "DBSettings.xml" located in "C:\ProgramData\Bentley\Promise CONNECT Edition\Configuration\Datasets\Promise\Config" to user machine after following the above steps. 




4. If there is change in Server and Database name from the Old Server to the New Server then the ECT.FID file needs to be updated with the New Server Name and Database Name. The ECT.FID file is usually present inside the Project Folder where the project is stored. 

Also See

Error "In order to create the database you must have the 'sysadmin' role permission" - Promis.e CONN...

Product(s): Promis.e CONNECT Edition Version(s): 10.00.XX.XX to 10.10.XX.XX Environment: NA Area: Database Platform Support Subarea: SQL Permission …

Last edited 8 months ago in OpenUtilities > OpenUtilities Wiki

Minimum SQL user permission for Promis.e users - Promis.e CONNECT

Product(s): Promis.e CONNECT Edition Version(s): 10.00.XX.XX to 10.10.XX.XX Environment: NA Area: Database Platform Support Subarea: SQL Permission …

Last edited 8 months ago in OpenUtilities > OpenUtilities Wiki

Original Author:

Satish Saptasagar