Image 1 - See this Visio menu in the image below To start, click the "File" menu and select "New" option, so Visio will provide a new Model Diagrams window (Image 1). Note that to use this you must first create an ODBC data source using the SQL Server Native Client driver and connect it to the database you wish to extract the schemas from.We will demonstrate step by step how to create this diagram and how to use this important resource for managing a database. I know there are other products out there that are much better for building database models, but to build a simple data model, Visio does the job and customers love its colors and the ability to open the model with Office when I need to discuss it with them.ĭon’t forget there is a “Reverse Engineer” option in Visio Professional and Premium editions to extract the database schema from an existing SQL Server database. This saves me from having to do all my diagramming in SQL Server/Visual Studio 2010 or another product. Alberto’s blog post about it is here, and you can download the add-in at Visio Forward Engineer Addin (NOTE: I could not get it to install properly until I first installed Microsoft. The resulting script has the create table statements, the alter table statements to add foreign key constraints and indexes, and even creates the code to drop objects if they already exist. There is an open source project from Alberto Ferrari that is an add-in for Visio 2010 that allows you to generate SQL Scripts from your database diagram. The last release that supported that was the Enterprise Architect version of Visio 2003, which required Visual Studio 2005 to be installed.īut there is help. If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to learn there is not a way to build CREATE TABLE scripts from your resulting diagram.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |