Hello
Does anybody know how reverse engineering works within Visio 2007
I'm trying to reverse engineer a number of tables
Currently, I can only create entities with a name plus some columns
How do I auto-create joins?
Thanks
if you need works with tables in visio try use VisioTablesAddin (https://github.com/Shishok/VisioTablesAddin) by Shisok (https://github.com/Shishok)
Sorry, i don't know what mean Reverse Engineer
Quote from: collierd on March 27, 2015, 01:16:54 PM
Does anybody know how reverse engineering works within Visio 2007
Hmm.. This is pretty well documented by Microsoft in the manual.. what do you mean?
https://support.office.com/en-za/article/Reverse-engineer-an-existing-database-into-a-database-model-fb034862-acfc-45bc-88b2-f33d1e1f8614#
There are numerous Videos also:
https://www.youtube.com/results?search_query=visio+reverse+engineer
Quote
I'm trying to reverse engineer a number of tables
Currently, I can only create entities with a name plus some columns
How do I auto-create joins?
It sounds like you are having some issue with reverse engineer? (i.e. it does not work as it should?) or?
In this case, we may need a bit more information.. Like, what type of the database are you reverse-engineering? MS SQL? Oracle? Something else?
And the relations (PKs/FKs) are not imported by the wizard? or?
Common pain point (https://connect.microsoft.com/SQLServer/feedback/details/365757/sql-server-2008-driver-for-visio-2007) is an issue when trying to reverse engineer SQL SERVER 2008 (or above) database with Visio 2007 (just shooting in the dark of course..)
The solution to this issue: do not select "Microsoft SQL Server" as provider when doing reverse-engineer, but select "ODBC Generic Driver" or "Generic OLEDB Provider" instead.
Ups. Sorry. Did not read properly the CAPTION of the topic. Silly me.
EXCEL! You are reverse-engineering EXCEL! :)
But are there even relations in Excel?! Like primary keys or foreign keys?
Normally these joins are supposed to be those (PKs/FKs). But does Excel really have something like this..?
I.e. what kind of "table relationships" you are going to display using these joins/arrows, if it's about Excel? Table relationships simply do exist in Excel, do they..?