Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Career advice for the IT professional
Browse by Tags · View All
SQLServerPedia Syndication 194
SQL Server 60
SSAS 40
#SQL SERVER 19
SSIS 18
2012/Denali 17
Career 17
Denali 14
SQL Server 2012 13
MDS/MDM 12

Archive · View All
June 2011 20
August 2011 15
July 2011 15
March 2012 15
October 2011 14
September 2011 14
May 2011 13
November 2011 12
February 2012 11
April 2012 10

James Serra's Blog

Create SQL Server scripts with Visio 2010

Dec 7 2011 12:00AM by James Serra   

If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to learn there is not a way to build CREATE TABLE scripts from your resulting diagram.  The last release that supported that was the Enterprise Architect version of Visio 2003, which required Visual Studio 2005 to be installed.

But there is help.  There is an open source project from Alberto Ferrari that is an add-in for Visio 2010 that allows you to generate SQL Scripts from your database diagram.  The resulting script has the create table statements, the alter table statements to add foreign key constraints and indexes, and even creates the code to drop objects if they already exist.  Alberto’s blog post about it is here, and you can download the add-in at Visio Forward Engineer Addin (NOTE: I could not get it to install properly until I first installed Microsoft .NET Framework 4).

This saves me from having to do all my diagramming in SQL Server/Visual Studio 2010 or another product.  I know there are other products out there that are much better for building database models, but to build a simple data model, Visio does the job and customers love its colors and the ability to open the model with Office when I need to discuss it with them.

Don’t forget there is a “Reverse Engineer” option in Visio to extract the database schema from an existing SQL Server database.  Note that to use this you must first create an ODBC data source using the SQL Server Native Client driver and connect it to the database you wish to extract the schemas from.

More info:

Video How To Use Microsoft Visio 2010 for Database Design


Republished from James Serra's Blog [70 clicks].  Read the original version here [32134 clicks].

James Serra
35 · 5% · 1664
2
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"Create SQL Server scripts with Visio 2010" rated 5 out of 5 by 2 readers
Create SQL Server scripts with Visio 2010 , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]