Alter script generation
Prev Chapter 3. Using PSQL Next

Alter script generation

Just before alter script generation we have to create PSQL XML file with alter information. To create such a file we have to import new logical model (XMI). New physical model is created. We have to save that file and follow steps bellow:

  1. Select the menu optionCompare->Compare with old version.
  2. Select the previous PSQL XML file version, which was used to create (alter) database.
  3. A new PSQL XML file is generated.
  4. Save this new file.
Alter PSQL file is a standard PSQL XML file, which can be used to generate create SQL script and for alter SQL script generation.

Save this new PSQL file for next generation of alter scripts.

Columns ordering defined in previous PSLQ XML file is preserved. Just ammend missing ordering in the new PSQL file.

Prev Up Next
Create script generation Home Chapter 4. Physical modeling in the UML