Comparison

Functionality

Within a Project, a Comparison encapsulates the following functionality:

• Select two Project Versions (schema versions) to compare

• Select comparison options (Object Selection, Comparison Scope)

• Perform the comparison

• Display the differences between the two versions as a result of the comparison

• Select object changes to be scripted (as CREATE, ALTER, DROP statements)

• Generate the change script

Terminology

Reference Version

The Project Version containing the target schema information (target version) to be upgraded to.

Difference Version

The Project Version containing the schema information (source version) to be upgraded from.

Typically, the Reference Version is taken from a development database, whereas the difference version is taken from a production database or a previous version of the development database.