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.
Run the PartsDatabaseMerge.exe file found in the resultingC:\BentleyDownloads\partsdatabasemergeutility01000000en\folder.
Follow the steps to complete the installation.
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.
Adding Manufacturer Data
Converting to an SQL Parts Database