THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Alberto Ferrari

Visio Forward Engineer 1.1

You know, I love Visio to develop simple databases and I have written a Visio add-in that performs the forward engineer of data models, called Visio Forward Engineer. Now I have found some time to update the project to version 1.1. You can download the add-in from the SQLBI website here.

The most important fix is that now it can be installed on computers without Visual Studio. Moreover, there are some features and limitations that I would like to share, just to answer the many questions I receive by e-mail about the project:

  • The tool is free and provided with full source code.
  • There is no support for calculated columns… sorry, but it cannot be added.
  • The primary key index is always crated as CLUSTERED, due to some limitation in the Visio library.
  • If you use a dot in the table name, as in “accounting.customers”, the add-in will automatically create the schema accounting and add the table to that schema. I find this simple feature very useful.
  • You can now add some SQL code to the generated script, useful for creation of views or other SQL objects. The default name of this code file is the same as the Visio with “SQL Code” appended at the end, as you can see in the figure

image

Happy downloading. Sorriso

Published Tuesday, October 19, 2010 1:54 PM by AlbertoFerrari

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Oscar Zamora said:

Any links for the binary for version 1.1?

Thanks

October 22, 2010 3:51 PM
 

AlbertoFerrari said:

@Oscar,

the download link is in the post. The zip file contains full source code and, in the "publish" folder, the setup binaries (to install without even looking at the code).

HTH

October 22, 2010 4:05 PM
 

Pablo Mugica said:

Thank You! Can't wait to try it.

October 23, 2010 11:20 AM
 

Mark Waterreus said:

Great update here. Happy to see it works flawless with Visio 2010 64-bit too!

October 25, 2010 2:24 AM
 

Terence Cassar said:

Well done and an excellent tool :D

November 19, 2010 6:00 AM
 

marc said:

Getting a certificate in non-trusted location error.  Any suggestions?

November 30, 2010 3:44 PM
 

some guy said:

@marc: I had the same issue.  Try "Unblock"ing all of the files in the publish directory (assuming WinXP, Right-click -> Properties -> Unblock button).

January 5, 2011 1:58 PM
 

Ella Bell said:

Thank you Alberto for taking effort and sharing the knowledge and information. I just love Visio for creating diagrams.

http://www.visiotoolbox.com

February 25, 2011 2:51 AM
 

Andrzej said:

Thanks a lot!!! Great tool! I was waiting for something like this since Enterprise Architect 2003.

April 19, 2011 11:17 AM
 

JW said:

I don't see the source code, only see the setup file after unzip.

November 3, 2011 4:55 PM
 

AlbertoFerrari said:

@JW, the code is under codeplex now, please refer to them for any further request. I think source code should be available, but your best option is to ask them. :)

November 3, 2011 5:25 PM
 

JW said:

Thank you Alberto. I wish one day the add-in generated script can have sql extened properties.

November 4, 2011 9:41 AM
 

TChill said:

Worthless...doesn't install in Win 7 and don't compile.

December 5, 2011 8:13 PM
 

jjjack99 said:

You need to take this file from winzip form, after which you can install

October 1, 2012 11:16 PM
 

Luis said:

Hi... i cant create script with nonclustered primary keys. i dont know how.

I have visio 2010.

Can you help me?

Thanks.

November 22, 2013 10:00 AM

Leave a Comment

(required) 
(required) 
Submit

About AlbertoFerrari

Alberto Ferrari is a Business Intelligence consultant. He his interests lie in two main areas: BI development lifecycle methodologies and performance tuning of ETL and SQL code. His main activities are with SSIS and SSAS for the banking, manufacturing and statistical sectors. He is also a speaker in international conferences like European PASS Conference and PASS Summit.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement