Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenUtilities
  • Product Communities
  • More
OpenUtilities
OpenUtilities Wiki Project Database Version - Substation
    • Sign in
    • +OpenUtilities
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • -OpenUtilities Substation
      • +CONNECT Edition - 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
        • Project Database Version - 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. 

    Project Database Version - Substation

      Product(s): OpenUtilities Substation
      Version(s): 08.11.07.158 - 10.06.00.22
      Environment: N/A
      Area: Database Platform Support
      Subarea: N/A

    Overview

    Each version of Bentley Substation has its own corresponding project database schema, identified by a version number. The version number of the database is stored as an extended property of the Project table in SQL Server databases and as a comment on the Project table for Oracle databases.

    When connecting to the project database, if the "Version" property/comment of the database does not match what Substation expects or cannot be retrieved for some reason, a Database version does not match the application message will appear.  Generally this means that either the Substation application or the database schema needs to be updated, whichever is older.

    Database version numbers can also be revealed in a prompt when restoring a project from a different version of Substation.  In this case, when the current project database version is newer than the database version for the backup listed in the message, the message is purely informational and no action is necessary.  If the database version of the backup is newer than the application, the backup cannot be restored and the message typically indicates this (Unable to restore project because the project's database version is newer than your current database version).

    The purpose of this document is to help determine the proper course of action, if any is necessary.

    Version Chart

    This chart applies to SELECT releases of Bentley Substation.

    Application Application Version Database Version
    Bentley Substation CONNECT Edition Update 6 10.06.00.22 10.0.13
    Bentley Substation CONNECT Edition Update 5 10.05.00.35 10.0.11
    Bentley Substation CONNECT Edition Update 4 10.04.00.30 10.0.09
    Bentley Substation CONNECT Edition Update 3 10.03.00.42 10.0.04
    Bentley Substation CONNECT Edition Update 2 10.02.00.31 10.0.03
    Bentley Substation CONNECT Edition Update 1 10.01.00.23 10.0.02
    Bentley Substation CONNECT Edition 10.00.00.232 10.0.01
    Bentley Substation V8i SS8 Refresh 2 08.11.13.140 8.1.45
    Bentley Substation V8i SS8 Refresh 08.11.13.73 8.1.38
    Bentley Substation V8i SS8 08.11.13.52 8.1.33
    Bentley Substation V8i SS7 Refresh Q1 2015 08.11.12.137 8.1.14
    Bentley Substation V8i SS7 Refresh Q3 2014 08.11.12.89 8.1.12
    Bentley Substation V8i SS7 Refresh Q2 2014 08.11.12.75 8.1.10
    Bentley Substation V8i SS7 REFRESH 08.11.12.64 8.1.10
    Bentley Substation V8i SS7 08.11.12.17 8.1.06
    Bentley Substation V8i SS6 08.11.11.14 8.0.72
    Bentley Substation V8i SS5 REFRESH 08.11.10.26 8.0.71
    Bentley Substation V8i SS5 08.11.10.25 8.0.69
    Bentley Substation V8i SS4 08.11.09.23 8.0.63
    Bentley Substation V8i SS3 08.11.08.18 8.0.56
    Bentley Substation V8i SS2 08.11.07.158 8.0.51

    Determining the application version

    The installed version of Bentley Substation (Application Version in the chart) can be found on the About Bentley Substation dialog.

    Determining the database version

    The current database version can be determined by connecting to the SQL Server using SQL Server Management Studio (SSMS) and checking the extended properties of the Project table in the database used by Substation.  In SSMS, expand Object Explorer > Databases > Substation* > Tables, right click dbo.Project, and select Properties > Extended Properties.

    Alternatively, executing the following query will also return the database version.

    use Substation
    SELECT * FROM fn_listextendedproperty ('Version', 'user', 'dbo', 'table', 'project', default, default)

    Replace "Substation" in the above query with the name of the database is not "Substation".

    Additional Notes

    • "SS" in the above chart stands for SELECTseries.

    • The version of the database that will be created by a script file can typically be found as a comment near the beginning of the script.  For example:
      --$DBVersion:8.1.33$--
       
      Similarly, an update script will list the version to which the script will update the database.

    • The SQL Server and database used by Bentley Substation can be determined by looking in the Project Database area of the Substation Setup dialog.

    See Also

    How to download the Bentley Substation software

    Creating and Updating the Project Database

    Error - Database version does not match the application

    Error - Unable to restore project, project's database version is newer

    Project Database Version - Promis.e

      Original Author: Matt_P
    • CONNECT Edition
    • v8i
    • Database Platform Support
    • SQL Server
    • Bentley Substation
    • en
    • Installation_Configuration
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Fri, Jan 18 2013 2:51 PM
    • Slavica Bozic Last revision by Bentley Colleague Slavica Bozic
    • When: Thu, Feb 6 2020 9:27 AM
    • Revisions: 24
    • 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

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