Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenUtilities
  • Product Communities
  • More
OpenUtilities
OpenUtilities Wiki Project Database SubVersion - Promis.e CONNECT
    • Sign in
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • -CONNECT Edition - Promis.e
        • +Administration Features - Promis.e CONNECT
        • +Automation Features - Promis.e CONNECT
        • +Component Features - Promis.e CONNECT
        • +Component Management - Promis.e CONNECT
        • -Database Platform Support - Promis.e CONNECT
          • Creating and Updating Project Database - Promise CE
          • Project Database SubVersion - Promis.e CONNECT
          • Project Database Version - Promis.e CONNECT
        • +Drawing Management - Promis.e Connect
        • +Installation_Configuration - Promis.e CONNECT Edition
        • +Maintenance Features - Promis.e CONNECT
        • +Migration - Promis.e CONNECT
        • +OS & Hardware Support - Promis.e CONNECT
        • +Panel Layout Mode - Promis.e CONNECT
        • +Power Platform Support - Promis.e CONNECT
        • +Print and Plot features Promis.e CONNECT
        • +Project Management - Promis.e CONNECT
        • +Reports_Output Features - Promis.e CONNECT
        • +Resolved issues in Promis.e Releases
        • +Wire Numbering - Promis.e CONNECT
        • +Wiring Feature - Promis.e CONNECT
      • 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
      • 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. 

    Project Database SubVersion - Promis.e CONNECT

      Product(s): Promis.e CONNECT
      Version(s):    10.08.XX.XX to 10.09.XX.XX
      Environment:  NA
      Area:  Database Platform Support
      Subarea:  NA

    Background:

    Each version of the Promis.e has its own corresponding database schema and "version" and “SubVersion” (SubVersion can only be found with Promis.e version Update 10 onwards) number property. When creating or updating the project database using Script, be sure the source material will create or update the database with the correct version and / “SubVersion” number.

    Hence for Promis.e version from 10.00.XX.XX to 10.07.XX.XX will have Database or Schema “Version”. But Promis.e Update 8 onwards when a database is created or updated it will have the same Database or Schema version as the earlier version and new “SubVersion” will be added to the Project Table properties. Due to these users can install Promis.e in the Staggered approach, hence due to which users with different Promis.e version can be able to work with the same Project Database as the Database version will be the same. And the SubVersion can be used to track the database up-gradation instead of the Database or Schema Version.

    In this article, we will see how users can check the “Version” and “SubVersion” of the Database or Schema.

    Steps to Accomplish

    The SubVersion for Promis.e can be determined via two Methods as below,
    1. Promis.e CONNECT UI ( Applicable for versions of Promis.e CE Update 9 and onwards).
    2. Executing SQL Script method (Clients using Promis.e CE Update 8 and SQL/IT Administrators who need to check the SubVersion but don't have Promis.e CONNECT installed)


    Promis.e CONNECT UI

    1. In Promis.e CONNECT go to Project Manager. 

    2. In Project Manager under the Admin Tools select Configure Database.


    3. In Configure Database dialog select the Database Version icon. Database Version dialog will pop up displaying on the upper side of the dialog the details of the Current Version of Promis.e CE that you are running and the Database Version and SubVersion associated with the Promis.e Version. 

     


    4. Now select the Database for which you need to check the Version and SubVersion and the details for the selected version will be dispalyed which can be compared to the current Promis.e version details on Top. 


    Executing SQL Script method

    1. Open SQL Server Management Studio (SSMS) and connect to the database that has the Project database for Promis.e.


    2. In SSMS select New Query >> and paste the below script in the query. Modify the Promis.e from “Use Promis.e” to be replaced with the actual name of the Project Database that needs to be checked for the Database or Schema Version and select Execute. See the below image for reference. Also, you can download the script from the below link







    3. Observer the Results for the Value Column for the Database SubVersion.

    Also See

      Original Author: Satish Saptasagar
    • administrator
    • Database Platform Support
    • en
    • Database
    • Promis.e CONNECT Edition
    • Share
    • History
    • More
    • Cancel
    • Satish Saptasagar Created by Bentley Colleague Satish Saptasagar
    • When: Wed, Jul 14 2021 1:46 PM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Fri, Aug 6 2021 6:41 AM
    • Revisions: 3
    • 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