For those of you who like ER datamodelling i Visio, the Visio 2010 plug-in at forwardengineer.codeplex.com is a MUST. Visio doesn’t have forward engineering out-of-the-box, so this plug-in is just what I need for my ER modelling. This plug-in is developed by the people at http://www.sqlbi.com/. The source code for the plug-in can be downloaded from codeplex as well.
- Download and install plug-in installation package from codeplex.com
- Install package
- Start Visio 2010
- Open a Visio Database diagram and look for the Forward Engineer tab on the menu
I recommend to use int/bigint identity as PKs. Otherwise, there are some hickups in the scheme generations for the plug-in.