Comparison

From dbscript Online Help
Jump to: navigation, search

Properties[edit]

See Comp-edit


Functionality[edit]

Within a Project, a Comparison encapsulates the following functionality:

  • 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.