The Merge method of the Database object merges the reference database with the base database.

Syntax

Script
Merge(
  reference,
  errorTable
)

Parameters

reference

The required Database object to be merged into the database.

errorTable

An optional name of a table to contain the names of the tables containing merge conflicts, the number of conflicting rows within the table, and a reference to the table with the merge conflict.

Return Value

Remarks

The MsiDatabaseMerge function and the Merge method of the Database object cannot be used to merge a module included within an installation package. They should not be used to merge Merge Modules into a Windows Installer package. To include a merge module in an installation package, authors of installation packages should follow the guidelines that are described in the Applying Merge Modules topic.

The Merge method does not copy over embedded cabinet files or embedded transforms from the reference database into the target database. Embedded data streams that are listed in the Binary Table or Icon Table are copied from the reference database to the target database. Storages embedded in the reference database are not copied to the target database.

If no table is provided, the general error message provides the number of tables containing merge conflicts. Any table can be passed in, but all other columns must be nullable because the operation to update the Error Table fails if a column is not nullable. A newly created table can be passed in as well because the Merge method automatically creates the columns it uses if merge conflicts are found. Two columns are used to present merge conflicts. The first column is the table name and the primary key column. The second column is the number of rows of that table that have merge failures.

If tables of the same name in both databases do not match in the number of primary keys, the column types, the number of columns, or the column names, the Merge method fails and posts an error message stating what occurred.

For the Error table to remain, the error handler must commit the database to which the Error table belongs. However, this commit should be done after using the third column to obtain the references to those tables where merge conflicts occurred.

If the method fails, you can obtain extended error information by using the LastErrorRecord method.

Requirements

See Also

Database

Send comments about this topic to Microsoft

Build date: 8/13/2009