Hello everybody,
I want to use Visio for Enterprise Architects (11.8207. SP3) to manage my database. The generation of a ddl file works fine but i have troubles with the reverse engineering. More precisly it always takes the master databse from the system tables as input.
I know that there is an option to switch the default database but it seems to have no affect.
Therefore i really wanted to redo my data source settings but i don't know how to delete them.
When i open Database - Reverse Engineering there i only have the possibility to choose an existing one or new, but not the possibility to delete one...
thx and kind regards
Hi Wuz,
Since my main area of expertise is with the customization and automation of Visio, I can't help much with the database solutions. In fact, it almost seems that such folks are a dying breed. Hopefully somebody smarter than me will catch this thread and help you out.
If not, try the general Visio newsgroups:
- Visio Newsgroups and Discussion Boards (http://www.visguy.com/2007/07/05/visio-newsgroups-and-discussion-boards/)
and, I've been collecting links for a Database Article, but you've beat me to the punch. Perhaps you can ask the guys who wrote these articles via the comments forms:
- Data Modeling in Microsoft Visio (http://blueink.biz/DataModelingVisio.aspx)
- Communicate your Database's Capabilities More Effectively With Ms Visio (http://www.articlesbase.com/databases-articles/communicate-your-databases-capabilities-more-effectively-with-ms-visio-210775.html)
- Exporting Tables to MySQL from Visio 2007 Pro (http://blueink.biz/DataModelingVisio.aspx)
- Create Data Disaster: Avoid Unique Indexes – (Mistake 3 of 10) (http://rapidapplicationdevelopment.blogspot.com/2007/08/create-data-disaster-avoid-unique.html)
- Inside the Sausage Factory: PART 05 (Refining the Data Model) (http://unhandledexceptions.spaces.live.com/blog/cns!FC56A7CB585DF52F!152.entry)
- Inside the Sausage Factory: PART 06 (Refining the Data Model) (http://unhandledexceptions.spaces.live.com/blog/cns!FC56A7CB585DF52F!168.entry)
- Inside the Sausage Factory: PART 07 (Refining the Data Model) (http://unhandledexceptions.spaces.live.com/blog/cns!FC56A7CB585DF52F!177.entry)
Good luck,
- Chris
Thx for your links they were quite helpful, let me add another one: http://www.devcow.com/blogs/adnrg/archive/2006/08/11/Reverse-engineer-or-design-a-database-with-Microsoft-Visio.aspx
To solution to my problem was to mage the datasoruces (ODCB) in the windows system management. There i was able to delete and add a new datasource, so i added a new System-DNS and it worked perfectly.
Pretty cool to have a roundtrip engineering between visio enterprise architects - mssqlserver
thx and cu
Nice report, Wuz!
You're the Database Expert now ;)