Difference between revisions of "How to compare database schemas"
(New page: === Terminology === '''Reference Version''' The Project Version containing the target schema information to be upgraded to. '''Difference Version''' The Project Version containing the...) |
(→Steps) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
=== Terminology === | === Terminology === | ||
| Line 20: | Line 19: | ||
* Create a [[Project Version]] in the Project containing the schema information of the Difference Version | * Create a [[Project Version]] in the Project containing the schema information of the Difference Version | ||
| − | * In the Project menu, select Comparison, New | + | * In the Project menu, select [[Comparison]], New |
* Enter an ID, select the Reference and Difference Versions, press Create | * Enter an ID, select the Reference and Difference Versions, press Create | ||
| Line 32: | 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 02: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
- 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
- In the Project menu, select Comparison, New
- 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
- In the Comparison menu, select Generate Script
- Press Generate, Download, and optionally Save
