This project is read-only.

User’s documentation

Introduction

As many of you could notice in a new version of Microsoft Visio 2010, as in previous versions, there is a possibility to draw and design database schemas. This is very useful feature, creates documentation, gives you the visual overview and simplifies the hands on. However Microsoft somehow in this version didn’t give us the possibility to transform our designs into scripts, in order to deploy easily and quickly what we designed. If you are unaware on how to create database design via Visio 2010 take a look on this video, http://www.microsoft.com/showcase/en/us/details/b0752c60-8ae2-4cdc-88c0-f8e08b96a360. This guide will show you how to create a database diagram from scratch and how to reverse engineer the diagram from already existing database. It is a good point from where to start.

Installing the add-in

The installation procedure is simple. Download the recommended version of add-in from the download page (http://forwardengineer.codeplex.com/releases/view/62782). Execute the setup file and follow the procedure. The procedure will check if all requirements are satisfied and if so will proceed. Further the installation will copy the needed files into chosen directory and register the add-in by adding the required keys into the registry.

These are the steps of installation procedure:

installation-1.png

Choose the installation folder and the scope of the add in:

installation-2.png

Click on next to install the add-in:

installation-3.png

Once installed, just click on close to end the installation procedure:

installation-4.png

Once installation is finished, open Visio and you should see the new ribbon available:

visio-1.png

Create your project and once the design is done, click on Forward Engineer ribbon:

visio-2.png

Now you have 2 choices:
  • Validate Data Model
  • Forward engineer

If you choose Validate Data Model your data model will be checked and you can follow the output window and check the validation messages:

visio-3.png

If your model is ready you can now generate the script. Choose Forward engineer button from the menu and you will get the following window:

visio-4.png

Now you have several options. You can choose database name, so all the script will contain USE directives pointing to the right database.

Last edited Mar 19, 2011 at 11:53 AM by MarioMajcica, version 12

Comments

sumit_2002 Sep 23, 2011 at 7:41 PM 
How to build from source ? I have Windows Vista running Visio 2010. The binary in download section seems to be a 64 bit binary and fails to run. If I try to download source and build locally it asks "Please provide crediantials for Team Foundation Server". Not sure what to do, would appriciate help.