Menu
I know this is probably not the right place to ask this question, but I don't know where else to turn. I tried google, but it hasn't helped me this time.
I have Visio 2007 Professional. I am trying to create a database model, complete with primary keys, foreign keys, and relationships. The problem is that I can't figure out how to get the database properties window to show. I tried double clicking the table entity, as well as the relationship entity, but nothing shows up. I tried running the script on this page, but it didn't work for me.
Any suggestions?
TIA!
703
Drag a View shape from either the Entity Relationship or Object Relational stencil. Double-click the shape to open the Database Properties window.
Can also be found under Shapes -> Software & Database -> Software -> Common Icons .
Connect SQL Server Data to DiagramsOn the Data tab, click Link Data to Shapes. Select the ODBC option and select ODBC DSN. Select the DSN for SQL Server, select the table you want to import, and finish the wizard. This article uses Orders as an example.
Close Visio, and open again, this time go through home page choosing the Data Model Diagram template. If you try opening the template from the Shapes window it sometimes doesn't show up. Closing and restarting worked for me :)
152
Click on the database tab at the top, and check/uncheck database properties.
39
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
