How to compare database schemas

From dbscript Online Help
Jump to: navigation, search

Terminology[edit]

Reference Version

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

Difference Version

The Project Version containing the schema information 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.

Steps[edit]

  • Create a Project Version in the Project containing the schema information of the Reference Version
  • Create a Project Version in the Project containing the schema information of the Difference Version
  • Enter an ID, select the Reference and Difference Versions, press Create
  • Press Calculate
  • The follow-up page shows a list of all differences between the two versions
  • In the Comparison menu, select Selection
  • Check all differences to be scripted, and press the Save Selection linkbutton
  • Press Generate, Download, and optionally Save