This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Database Schema Diagram
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 09, 2008
10:29 AM
Database Schema Diagram
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.
Thanks.
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 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?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 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.
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.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 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.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 09, 2008
12:59 PM
Excellent idea! I should have thought of that as well. 🙂
Thanks, I think that would work.
Thanks, I think that would work.