![]() ![]() Just drag and drop an Entity Shape from the Shapes menu onto the diagram. Visio 2010 provides you with shapes to create your own database schema within a Database Model Diagram. The complete Reverse Engineer diagram generated by the Wizard. This image is a close up of the complete diagram The diagram appears with the tables displaying the Primary and Foreign Keys and the 1 to many relationships between the tables automatically. If you are done, click Finish to generate the diagram. Review the tables that you selected in the previous step. ![]() Select the tables that you would like in the diagram from the list. Here I have selected just Tables with the Keys and Indexes. This tool will not work with later versions of SQL Server such as 2012 or 2014.Ĭlick the objects that you want to appear in the Database Diagram. In the Data Sources list box, I have selected the AdventureWorks database from my 2008R2 SQL Server. Microsoft SQL Server is selected here, but other databases such as DB2, Oracle, MS Access, and generic OLE and ODBC drivers areĪvailable. The Wizard appears and you can select the database drivers from the drop down box. To get started, open Visio 2010, select Software and Database from the Template Categories, and select Database Model Diagram from the Templates available.įrom the Ribbon, select the Database tab and click on Reverse Engineer to start the Wizard.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |