Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Moving Projects
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • +CONNECT Edition - Promis.e
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • +Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • +Database Platform Support - Promis.e
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • +PowerPlatform Support - Promis.e
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • +Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • -Project Management - Promis.e
        • -Backup and Restore Project - Project Management - Promis.e
          • Backup Project
          • Backup Your Data
          • Error - DB_Restore_BlkInfo on project restore
          • Error - Project was created in database version
          • Error - There are error during restore, rebuild this project to fix it
          • Error - Unable to restore project, project's database version is newer
          • Error on backup - ExecuteSQL error...Syntax error in INSERT INTO Device_Partnumber
          • Error on backup - ODBC connection
          • Error on Backup - The field is too small
          • Error on Backup - You still have page(s) active belong to the project
          • Error on Backup and Restore: System cannot find the file specified
          • Error on project restore - index outside bounds of array
          • Install SQL Server Management Studio
          • Moving Projects
          • Restore Project
          • Restore Sample Projects
          • Submittal Bill Of Materials (SBOM)
        • +BOM Explorer - Project Management - Promis.e
        • +Project Manager - Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    Moving Projects

      Product(s): Promis.e, Bentley Substation
      Version(s): through 08.11.13.140
      Environment: N/A
      Area: Project Management
      Subarea: Backup and Restore Project

    Background

    It is sometimes necessary or desired to move projects or the project database from one computer to another.

    Common situations include:

    • Moving Promis.e or Bentley Substation to a new workstation in a single user environment.
    • Moving the projects from a “standalone” workstation to a network server(s) to enable the sharing of projects in a multi-user environment. Check with the IT department to ensure that the proper machine has been chosen to host the SQL Server.
    • Moving projects from a network configuration to a local configuration so work can be done away from the network.
    • Moving the database from one server to another.

    Please note that after moving from a local setup to a network setup you may notice a decrease in performance. Promis.e and Bentley Substation require a consistent 35 megabits per second transfer rate, and what is actually achieved by the network is not the same as the equipment ratings of the network.

    Steps to Accomplish

    Method 1

    The most reliable way to "move" the SQL project data, and the method Bentley Technical Support analysts are most able to support, is the following process:

    1. On the source machine(s), backup all the projects to be moved using Project Manager while the existing configuration is still valid (before moving or changing anything).  Projects are backed up individually, and each project backup results in a .PRJ archive file.

    2. Install SQL Server on the destination machine (if applicable and not already existing) and create a new project database on it.  See Creating and Updating the Project Database. When moving to a different workstation in a single-user environment, the "destination machine" would be the new workstation and this step may have already been completed.

    3. Specify the new server name and database name in the Project Database area of the Setup dialog.  When moving to a different workstation in a single-user environment, this is done on the Setup dialog on the new machine, and this step may have already been completed.

    4. Restore the project backup files (.PRJ files) created in step 1. This will extract the project folders to the paths you specify and inserts the project data into the database to which the software is currently connected.

    Note: Backing up projects does not delete them.  Therefore it is possible to end up with instances of the same project on multiple machines and users unknowingly working on different instances.  It is up to the user to implement or enforce some method of control to avoid this situation.

    Method 2

    This method requires some familiarity with the administration of SQL Server, and involves backing up and restoring the SQL project database(s). It should be performed while there are no users using Promis.e/Bentley Substation. SQL Server Management Studio is included with some Promis.e and Bentley Substation packages, otherwise see Install SQL Server Management Studio. SQL Server Management Studio can be installed on a machine other than the source and destination servers, but you will need access to the servers' hard drives in order to retrieve and copy the database backup file.

    1. Backup the critical projects using Project Manager while the existing configuration is still valid (before moving anything).  Projects are backed up individually, and each project backup results in a .PRJ archive file.  These backups could be restored into a new database if moving the database is not successful.

    2. Backup the SQL project database(s) on the source server using SQL Server Management Studio.  This will result in a .BAK file.  Determine the database to backup and the server that hosts it by looking at the Setup > Project Database dialog.

    3. Backup the project folders now, just in case.  This way the backup of the project folders will be synchronized with the backup of the database.

    4. Install SQL Server on the destination machine (if not already existing).

    5. On the destination machine Restore the backup (.BAK) created in step 2, again using SQL Server Management Studio.

    6. Create the login(s) that will be used to connect to the destination SQL Server and associate the login(s) with the database.  This step is necessary because the login is associated with the server, not the database, so transferring the database does not transfer the login.  If using Windows Authentication, each connecting user would need to be setup; if using SQL Server Authentication, a generic login can be created and used by all users, see the Creating an SQL Server Login article. The script in the article should be executed for each project database being moved.

    7. Move the project folders to the new location, if applicable.

    8. On the Project Database area of the Setup dialog of each workstation, set the configuration to use new SQL server and/or database, and the appropriate login information.

    9. Ensure the projects affected by the move are accessible to users.
    10. Decommission the old database/server.

    Alternatively, instead of backing up and restoring the SQL database in steps 2 and 4, the database (.MDF) and transaction log files (.LDF) can be moved to the new server machine and "attached" to the new SQL Server. SQL Server Management Studio is still required for this task. Note: A database named "promise" would have two related files: promise.mdf and promise_log.ldf. Both are required. These files are typically found in the SQL Server DATA folder.

    See Also

    Backup Project

    Restore Project

    Creating and Updating the Project Database

    SQL Server Login

    Finding the SQL Data folder

    External Links

    How to: Back Up a Database (SQL Server Management Studio)

    How to: Restore a Database Backup (SQL Server Management Studio)

    How to: Attach a Database (SQL Server Management Studio)

    How to: Create a SQL Server Login

      Original Author: Matt_P
    • Backup and Restore Project
    • Database Platform Support
    • promis.e
    • Administration
    • SQL Server
    • how to
    • Bentley Substation
    • en
    • Project Management
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Fri, Mar 25 2011 3:24 PM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Fri, Apr 3 2020 6:51 AM
    • Revisions: 26
    • 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