You are currently reviewing an older revision of this page.
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 Import and Export Data tool included with recent versions of SQL Server, including Express, is an alternative to using the Parts Database Merge Utility that has the additional capability of copying data between Access databases and SQL databases.
Run the PartsDatabaseMerge.exe file found in the C:\BentleyDownloads\partsdatabasemergeutility01000000en\folder.
Follow the steps to complete the installation.
Note: the Parts Database Merge Utility cannot merge fields that are the memo data type, so do not include the "Additional_Part" or any "User" or "Memo" fields in the field mapping step to avoid "overflow" errors.
Adding Manufacturer Data To promis.e