PDA

View Full Version : Database Schema Diagram



DLee65
06-09-2008, 10:29 AM
Does InstallShield have a Database Schema diagram for the changes to IS2009? We integrated our prerequisites into our build system rather than using the locations that ship with IS2009. As such it would be good to know that we have covered the bases for relationships between tables in the Direct Editor.

Thanks.

MichaelU
06-09-2008, 12:40 PM
I don't believe we have such a diagram. Prerequisites, which you mention, should not have changed in terms of their ability to use, or where they store, build paths. There is a new table for associating prerequisites with features. There are new tables for other IS2009 features and MSI4.5(b2) features. Do you have any other particular tables you'd like to ask about?

DLee65
06-09-2008, 12:46 PM
My coworker would like to know all the new table relationships. Since we use non-default directories as the source of our prerequisites, this forces us to have to edit the Direct Editor manually rather than using the UI. So in this particular case we wanted to be sure that we do not leave out any necessary foreign key relationships.

I just figured that a good Database Schema Diagram would work well to do this; I was hoping that you might have one for at least all the InstallShield tables you work with.

MichaelU
06-09-2008, 12:57 PM
As a general policy we do try to fill out the _Validation table correctly. This table is not shown in the IDE (largely because bad edits to it can render our IDE unusable), but it contains higher level contextual information like what kinds of strings are allowed in a string column, or what columns are foreign keys into other tables. Perhaps this table (or a summary extracted from it) would provide what you're looking for already? You can use the InstallShield MSI Diff tool, or ORCA, etc., to view this table, and MSDN describes its format.

DLee65
06-09-2008, 12:59 PM
Excellent idea! I should have thought of that as well. :)

Thanks, I think that would work.