Jump to content


This is a ready-only archive of the InstallSite Forum. You cannot post any new content here. / Dies ist ein Archiv des InstallSite Forums. Hier können keine neuen Beiträge veröffentlicht werden.
Photo

What is Schema version?


1 reply to this topic

bhagelin

bhagelin
  • Members
  • 22 posts

Posted 31 August 2005 - 20:40

Using InstallShield 11, in the SQL Scripts view, with a particular SQL script highlighted, there is a field for "Schema version".

What is Schema version, and how is it utilized? Is there any literature where I can read about this feature? I haven't found much on it so far.

Edited by bhagelin, 31 August 2005 - 20:41.


bhagelin

bhagelin
  • Members
  • 22 posts

Posted 01 September 2005 - 15:50

Please disregard this post, as I have found the answer I was looking for.


Schema version is a version number assinged to a particular SQL script. That version number is then stored in a table built by InstallShield. Every subsequent SQL script has it's Schema version number checked against the number in the database, and the script is only run if it's version number is greater than that which is in the database.

Edited by bhagelin, 01 September 2005 - 15:52.