Image 5 - See this Drivers and Data Source window in the image below The first configuration you may define to get your table structure will select 'Microsoft SQL Server' driver and configure the 'Data Source' to use(Image 5). Soon as you click 'Reverse Engineer' button initializes an Reverse Engineering wizard to get structure object selected for import into your new document. Image 4 - See this menu option in the image below Let's begin the Reverse Engineering of our database through Visio at new page Data Model diagram, click on the 'Database' menu and select 'Reverse Engineer' button (Image 4). If you want to modify and customize document and/or objects layout make this change after Reverse Engineering implementation. We will not modify, any property on this blank page and not add other objects. This is because we can lose some of the changes and customizations.

Image 3 - See this output SQL script in the image below Double-click on diagram and a new blank page will be available for create our tables. In this sample, we use the 'Database Model' diagram (Image 3), that will enable to recognize all objects related to SQL Server Database. Once you select the 'Software and Database' model, will be displayed several diagrams to your choice. Image 2 - See this Template window in the image below If this option is not available, simply use the option to 'Add/Remove Programs' in 'Control Panel' on Windows OS and reinstall this 'Models' option. The Model Diagrams displayed on this screen are pre-installed with Visio. In this Reverse Engineering task, we need to select the 'Software and Database' option (Image 2). 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). We will demonstrate step by step how to create this diagram and how to use this important resource for managing a database.

Sql server visio stencil