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.
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 OpenUtilities Substation (OUS) CONNECT.
1. First Determine the SQL Server that you are planning to use with OUS. Then Create a New Project Database on the Server for OUS using the steps in the below Wiki Link.
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.
1. Check the compatibility of the SQL Server with OUS version using the below Compatibility Chart to sure that compatible SQL Server is being used.
1. Backup the Database from the old SQL Server. 2. Restore the Database on New SQL Server. 3. Then configure the new Database in OUS 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\OpenUtilities Substation CONNECT Edition\Configuration\Datasets\Substation\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.