Within a Project, a Comparison encapsulates the following functionality:
- Select two Project Versions (schema versions) to compare
- 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
The Project Version containing the target schema information (target version) to be upgraded to.
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.