Reverse Engineering in MS Visio

Hi, If you want to reverse Engineering the model, First check MS visio version you are using. The option only available in MS Visio 2007 -- **Professional Edition**.

Then you proceed the below steps.


1. On the File menu, point to New, point to Database, and then click Database Model Diagram. 2. On the Database menu, click Reverse Engineer. 3. On the first screen of the Reverse Engineer Wizard, do the following: • Select the Microsoft Office Visio database driver for your database management system (DBMS). If you have not already associated the Visio database driver with a particular 32-bit ODBC data source, do so now. • Select the data source of the database you're updating. If you have not already created a data source for the existing database, do so now. Note When you create a new source, its name is added to the Data Sources list. • When you are satisfied with your settings, click Next. 4. Follow the instructions in any driver-specific dialog boxes. For example, in the Connect Data Source dialog box, type a user name and password, and then click OK. 5. Select the check boxes for the type of information you want to extract, and then click Next. 6. 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. 7. If you selected the Stored Procedures check box in step 5, select the procedures that you want to extract, or click Select All to extract them all, and then click Next. 8. Select whether you want the reverse engineered items added automatically to the current page. 9. Review your selections to verify that you are extracting the information you want, and then click Finish. The wizard extracts the selected information and displays notes about the extraction process in the Output window. 10. Create a diagram of your model by • Dragging the tables you want to view from the Tables and Views window onto the drawing page. • Selecting a table, and then on the Database menu, clicking Show Related Tables to view the tables related to the selected table.