Comparison
Properties[edit]
See Comp-edit
Functionality[edit]
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[edit]
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.
