Hi,
i know that this is a long shot, but many years ago I came across a tool that could read MSI database file and convert them to access files, purely for the visualisation of the relationships between the tables. Does anyone still have this in their bag of tools? (VBScab, Captain or perhaps EdT?)

Cheers
Phil
Answer Summary:
Will need to develop the required functionality myself. The tool that I mentioned in the header is obviously no longer available.
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

0
I've not to be honest.  Like VBScab says, it's doable using the API.  It just requires a (fair) bit of legwork.  Alternatively if you just need it 'purely for the visualisation of the relationships between the tables' then InstEd could work?

In this screenshot I have highlighted a row in the Component table and it has told me the relationship at the bottom.



If you wanted some diagrams (although these aren't great) you could try:


etc...
Answered 07/19/2016 by: captain_planet
Third Degree Brown Belt

  • Hi Captain,
    thanks for the pointers, was aware of these. If I remember correctly, seeing these relationship diagrams was the initial spark of looking (and eventually) finding something many years ago (must have been around 2002 or so).
    Cheers
    Phil
Please log in to comment

Answers

1

Sorry, no, I have nothing like that but it's a great idea! It should be too hard to create one, though. As you know, there is an object model and the sample MS scripts could be leveraged to make a start on querying the tables.

You might hit a snag with custom tables but, again, I think one of the sample scripts queries the schema so...

Good luck!

Answered 07/18/2016 by: VBScab
Red Belt

  • I would sit down and try it myself, but as I mentioned, someone has already done it. I did have the application (command line tool) but cannot find it anywhere... Perhaps EdT has it in his bag of tools...
Please log in to comment
1
in the past if we have had to do this we have exported the tables from orca, then run a bat file that renames the ibt files to .txt and runs a bulk import to a new access database file named after the package, i will try and dig it out if i can
Answered 07/18/2016 by: sparky86
Fourth Degree Brown Belt

  • Hi Sparky, would be nice if you could share your example as a kick-off point...
    Cheers
    Phil
Please log in to comment
0
Hi Guys,
thanks for the feedback...
I was hoping to avoid having to program it myself (bit lazy at the minute) as it really is only donkey work (Read _Tables, for each entry read the _Columns, assign, check for FK's perhaps read through the _Validation to ensure that the FK's are valid, build the classes and then dynamically build the (access) db... lot's of footwork..
When I have a spare couple of days I'll sit down and have a look.

Cheers
Phil
Answered 07/20/2016 by: Pressanykey
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity