#Microsoft er diagram tool driver#

You can add and customize tables and views, create relationships, and customize columns and data types. Microsoft Office Visio makes it easy for IT and business professionals to visualize, explore, and communicate complex information. After you create a database model diagram, the work of refining the diagram begins.Review your selections to verify that you are extracting the information that you want, and then click Finish.Select whether you want the reverse engineered items to be added automatically to the current page.Select the check boxes for the tables (and views, if any) that you want to extract, or click Select All to extract them all, and then click Next.

In the Connect Data Source dialog box, type a user name and password, and then click OK.When you are satisfied with your settings, click Next.If you have not already created a data source for the existing database, click New to do so now. Select the data source of the database that you are updating.

#Microsoft er diagram tool driver#

If you have not already associated the Visio database driver with a particular ODBC data source, click Setup.

Select the Microsoft Office Visio database driver for your database management system (DBMS).

On the first screen of the Reverse Engineer Wizard, do the following:.

Open Microsoft Office Visio, then on the File menu, point to New, point to Software and Database, and then click Database Model Diagram and on the Database menu, click Reverse Engineer.

Firstly, besides the tool mentioned by Uri Dimant, you can also use visio: