I know numerous developers that build databases by hand, but of all my software development tools I believe a data modeler is by far the most important.
#Sql server database modeling tools how to#
The data modeling section will provide an overview of why to use a data modeling tool, then will delve into the details of using Visio, including how to create a new model, how to modify tables and relationships, and how to comment a data model. For some background on how to read the crow's feet notation that Visio uses see my Blog post An Entity Relationship Diagram Example Data Modeling This document assumes a basic understanding of data modeling design concepts. This document will go over how to use Visio to perform data modeling tasks and how to maintain a database with Visio, while providing tips from someone who has multiple years of experience with the tool. I’ve used it extensively with SQL Server 7, SQL Server 2000, SQL Server 2005, and Oracle 8i, but it should work with any ODBC accessible database.
#Sql server database modeling tools update#
Update existing databases from models, keeping all.Generate new databases (in a number of different.Reverse engineer models from existing databases.Visio is not particularly intuitive or well documented, and is occasionally buggy, but once you get used to it it is very useful (and relatively inexpensive). In addition to a basic line-to-shape drawing tool, Visio can model UML, generate and reverse engineer interfaces in code (no implementation is generated, unlike Automated Architecture's Blue Ink tool), and as is the focus of this article: provide a fairly strong tool for data modeling. Microsoft Visio, Enterprise Architect edition, is a powerful software development tool for numerous applications. While Visio can perform many Rapid Application Development tasks (including Code Generation from UML diagrams), this article provides an in-depth view of how to use Microsoft Visio for data modeling.
Somewhat surprisingly Microsoft Visio is a true Rapid Application Development tool as envisioned by James Martin. PATH: HOME // ARTICLES // Data Modeling in Visio Data Modeling in Microsoft Visio - A Tutorial for a useful Software Development Toolīlue Ink Technical Details | Rapid Application Development | Data Modeling in Visio
0 kommentar(er)
