SQL Server or other third party database products such as Oracle and IBM DB2 can use the Visio functionality to outline a companies storage of data through active digrams that automate how data is stored and used. The program enables IT Adminstrators to create Diagrams for Active Directory role outs for Windows 2000 Server and Server 2003. You can export diagrams as a webpage so that users who don't have Visio installed locally on their machine can View diagrams through web browser at different resolutions with ease. You can create custom stencils save them and share with other Visio users over a corporate network. Users are able to import Native Auto CAD drawings directly into Visio, and use the Visio tools to further customize and edit drawings to their hearts content. The program still lacks certain elements of Microsoft Office which I feel concerned about. Version 2003 is no exception and improves upon its predecessor with support for the web and integration with other Office applications. The result of this process is a nicely layouted diagram of the corresponding database.Visio has always been an excellent solution for technical diagramming. Visio Generic ODBC DriverĪfter filling in the correct username and password, you can for instance specify which object types you’d like to reverse engineer. If the User Data Source was successfully added, you should be able to select the “Generic ODBC Driver” and the specified PostgreSQL data source. Creating a PostgreSQL User DSN Creating a PostgreSQL User DSN Enter your database connection credentials and test it. Choose “User Data Source” and “PostgreSQL Unicode”, as seen in the following screenshots. Now, select ‘Reverse Engineer’ and create a new data source. Select the “Database” tap, and your window should look like this: Visio Reverse Engineering Second, you can start Visio and create a new “Database Model Diagram”. Therefore, the first thing you need to do is to install the PostgreSQL ODBC driver. This little tutorial assumes that the database to be reverse engineered is a PostgreSQL installation. Microsoft Visio supports such a reverse engineering of most databases in a remarkably easy way. When working with relational databases it might come in handy to visualize an existing schema.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |