The GenerateTransform method of the Database object creates a transform that, when applied to the object database, results in the reference database. The transform is stored in the storage object.

If the transform is to be applied during an installation you must use the CreateTransformSummaryInfo method to populate the summary information stream.

Syntax

Script
GenerateTransform(
  reference,
  storage
)

Parameters

reference

Required database that does not include the changes.

storage

The name of the generated transform file. This is optional.

Return Value

Remarks

A transform can add non-primary key columns to the end of a table. A transform cannot be created that adds primary key columns to a table. A transform cannot be created that changes the order, names, or definitions of columns.

This method returns a Boolean value. It returns TRUE if a transform is generated. It returns FALSE if a transform is not generated because there are no differences between the two databases. If the method fails, it generates an error.

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

Requirements

See Also

Database

Database Transforms

Send comments about this topic to Microsoft

Build date: 8/13/2009