Difference between revisions of "How to compare database schemas"

From dbscript Online Help
Jump to: navigation, search
(Steps)
(Steps)
Line 31: Line 31:
 
* Check all differences to be scripted, and press the Save Selection linkbutton
 
* Check all differences to be scripted, and press the Save Selection linkbutton
  
* In the Comparison menu, select Generate Script
+
* In the Comparison menu, select [[Script Generation|Generate Script]]
  
 
* Press Generate, Download, and optionally Save
 
* Press Generate, Download, and optionally Save

Revision as of 01:01, 6 November 2008

Terminology

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

  • 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