Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki How to Migrate from Old SQL Server to New SQL Server for OpenUtilities Substation CONNECT
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • -OpenUtilities Substation
      • -CONNECT Edition - OpenUtilities Substation
        • +3D Layout Features - OpenUtilities-Substation
        • +Administration Features - OpenUtilities Substation
        • +Automation Feature
        • +Component management - OpenUtilities Substation CONNECT
        • +Components Features - Substation CONNECT
        • +Construction Drawing - Openutilities Substation CONNECT
        • -Database Platform Support - OpenUtilities Substation
          • Creating and Updating the Project Database - Substation CE
          • How to Migrate from Old SQL Server to New SQL Server for OpenUtilities Substation CONNECT
          • How to resolve "Transaction log is full" error while deleting Projects
          • Installing SQL Server Express locally for OpenUtilities Substation CONNECT
          • Project Database SubVersion - OpenUtilities Substation
          • +SQL User Permissions - OpenUtilities Substation CONNECT
          • Updating Database for OpenUtilities Substation CONNECT Update 10 and through
        • +Drawing Managment - OpenUtilities Substation
        • +Installation_Configuration - Bentley Substation CONNECT Edition
        • +Maintenance Feature - Open Utilities Substation CONNECT
        • +Migration - OpenUtilities Substation CONNECT
        • +OS & Hardware Support - OpenUtilities Substation CONNECT
        • +Panel Layout- Substation CONNECT
        • +Power Platform Support - Substation CONNECT
        • +Print and Plot feature
        • +Print and Publish feature
        • +Project Management - OpenUtilities Substation CE
        • +ProjectWise Integration - OpenUtilities Substation CONNECT
        • +Replace Device ID - Find_Replace - OpenUtilities Substation
        • +Reports_Output Features - OpenUtilities Substation CONNECT
        • +Resolved issues in OpenUtilities Substation Releases
        • +Wire Numbering - Substation CONNECT
        • +Wiring Feature - OpenUtilities Substation
      • +3D Layout Features - Bentley Substation
      • About Bentley Substation
      • +Administration Features - Bentley Substation
      • +Automation Features - Bentley Substation
      • +Component Management - Bentley Substation
      • +Construction Drawings - Bentley Substation
      • +Database Platform Support - Bentley Substation
      • +Grounding Grid - Bentley Substation
      • How to log Service Request
      • +Installation_Configuration - Bentley Substation
      • +Interoperability - Bentley Substation
      • +PowerPlatform Support - Bentley Substation
      • +Project Management - Bentley Substation
      • +ProjectWise Integration - Bentley Substation
      • Working from home with OpenUtilities Substation
    • Promis.e Paths
    • +Promis.e Wiki
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

     
     Questions about this article, topic, or product? Click here. 

    How to Migrate from Old SQL Server to New SQL Server for OpenUtilities Substation CONNECT

      Product(s): OpenUtilities Substation CONNECT Edition
      Version(s):  10.00.XX.XX to 10.14.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 OpenUtilities Substation (OUS) CONNECT. 



    How to do Auto-Backup of Projects in OpenUtilities Substation
    Product(s): OpenUtilities Substation CONNECT Version(s): 10.06.XX.XX to 10.11.XX.XX Environment: N/A Area: Maintenance Feature Subarea: N/A Background…
    Last edited over 1 year ago in OpenUtilities > OpenUtilities Wiki


    Steps to Follow

    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. 

    Creating and Updating the Project Database - Substation CE
    Product(s): Substation CONNECT Version(s): 10.00.XX.XX to 10.05.XX.XX Environment: N/A Area: Installation_Configuration Subarea: N/A Background…
    Last edited over 3 years ago in OpenUtilities > OpenUtilities Wiki



    2. 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. 




    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. 

     

    How to Restore a Project in OpenUtilities Substation CONNECT
    Product(s): OpenUtilities Substation CONNECT Edition Version(s): 10.00.XX.XX to 10.14.XX.XX Environment: NA Area: Project Management Subarea: Backup…
    Last edited 6 months ago in OpenUtilities > OpenUtilities Wiki






    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 OUS version using the below Compatibility Chart to sure that compatible SQL Server is being used. 

    Compatibility Chart OpenUtilities Substation CONNECT
    1. Compatibility Chart for Substation CONNECT UPdate to OpenUtilities Substation CONNECT Update 7 2. Compatibility Chart for OpenUtilities Substation CONNECT update 8 to 1 2 3. Compatibility Chart…
    Last edited over 1 year ago in OpenUtilities > OpenUtilities Wiki



    2.  The Details related to Server Name and Database name is stored inside each project folder inside ECT.FID file which is used by OUS 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 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. 








    Also See

    Minimum SQL user permission for Promis.e users - OpenUtilities Substation CONNECT
    Product(s): OpenUtilities Substation CONNECT Edition Version(s): 10.00.XX.XX to 10.13.XX.XX Environment: NA Area: Database Platform Support Subarea: …
    Last edited 8 months ago in OpenUtilities > OpenUtilities Wiki


    Error "In order to create the database you must have the 'sysadmin' role permission" - OpenUtilities...
    Product(s): OpenUtilities Substation CONNECT Edition Version(s): 10.00.XX.XX to 10.13.XX.XX Environment: NA Area: Database Platform Support Subarea: …
    Last edited 8 months ago in OpenUtilities > OpenUtilities Wiki



      Original Author: Satish Saptasagar
    • Database Platform Support
    • SQL Server
    • Migration
    • en
    • OpenUtilities Substation
    • Share
    • History
    • More
    • Cancel
    • Satish Saptasagar Created by Bentley Colleague Satish Saptasagar
    • When: Fri, Mar 3 2023 9:30 AM
    • Revisions: 1
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies