Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenUtilities
  • Product Communities
  • More
OpenUtilities
OpenUtilities Wiki Parts Database Merge Utility
    • 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
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • -Component Management - Promis.e
        • Adding Manufacturer Data
        • +Catalog Manager - Component Management - Promis.e
        • +Create Macro - Component Management - Promis.e
        • +Create Symbol - Component Management - Promis.e
        • +Family Creation - Component Management - Promis.e
        • -Parts Database - Component Management - Promis.e
          • Error - Invalid Operation when adding a new part record - OID field
          • Error - Object reference...CheckField on Parts Database Manager
          • Error - The value of Attribute_Text is invalid
          • No Browse button for custom mode symbols on Parts Database Manager
          • Parts database changes not reflected in project
          • Parts Database Manager
          • Parts Database Merge Utility
          • Quick Filtering in the Parts Database Manager
          • Quickly Navigate To Part Number Records in Promis.e Connect
          • Specify multiple symbols for one mode in a part number record
          • Unmapped fields cannot be moved on Parts Database Manager Customization
          • Wrong part numbers listed in Select Part Number
        • Sharing content across multiple sites
        • +Terminal_Pin_Plug Manager - 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. 

    Parts Database Merge Utility

      Product(s): Promis.e, Bentley Substation
      Version(s): N\A
      Environment: N\A
      Area: Component Management
      Subarea: Parts Database

    Background

    The Parts Database Merge Utility copies selected rows from a table in one database to a table in another database. It was developed to merge part number records from manufacturer parts databases into the main parts database used by the software. It is an alternative to using Microsoft Access to copy the data.

    The Parts Database Merge Utility is a legacy application with limitations, foremost is the inability to include fields of the Memo data type. The Import and Export Data tool included with recent versions of SQL Server, including Express, is an alternative to using the Parts Database Merge Utility. It has the additional capability of copying data between Access databases and SQL databases.

    Steps to Accomplish

    Download

    1. Download partsdatabasemergeutility01000000en.zip from the Files area.

    Install

    1. Extract and run partsdatabasemergeutility01000000en.exe from the downloaded .zip file.
    2. Run the PartsDatabaseMerge.exe file found in the resulting
      C:\BentleyDownloads\partsdatabasemergeutility01000000en\
      folder.

    3. Follow the steps to complete the installation.

    Run

    1. Double-click the Promis-e Database Merge shortcut on the desktop. Alternatively, run dbmerge.exe. This file is installed in C:\dbmerge\ by default but may be located elsewhere.
    2. Consult the "Database Merge Tool Instructions.pdf" file regarding the use of the utility. These files are found in the
      C:\BentleyDownloads\partsdatabasemergeutility01000000en\
      folder.

    Note: the Parts Database Merge Utility cannot include fields that are the Memo data type during the merge, so do not include the "Additional_Part" or any "User" or "Memo" fields in the field mapping step to avoid "overflow" errors.

    See Also

    Adding Manufacturer Data

    Converting to an SQL Parts Database

      Original Author: Matt_P
    • parts database
    • promis.e
    • Bentley Substation
    • en
    • SELECTsupport
    • Component Management
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Thu, Sep 10 2015 11:59 AM
    • Matt_P Last revision by Communities MVP Matt_P
    • When: Wed, Aug 16 2017 10:21 AM
    • Revisions: 4
    • 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