Tools to Generate SQL Server 2005 Database???

Question

Tools to Generate SQL Server 2005 Database???

philliard

Newbie

Points: 4
More actions
January 12, 2010 at 12:04 pm

#386085

I am helping a small nonprofit organization generate a SQL Server database. DDL has been generated from Visio for Enterprise Architect (2002), but they have no tools to actually create the database. What tool(s) would you recommend to generate a database? They have SQL Server 2005 but may go to 2008.
Thanks

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

If they have the DDL in scripts (text files?), you should be able to open those and run them in SSMS (SQL Server Management Studion) which is a part of SQL Server 2005/2008.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Not only that, but IIRC, you should be able to connect Visio directly to SQL Server 2005/2008 and create the tables directly.

Lowell SSC Guru Points: 323547 More actions · Answer 3

i think the basic version of SQLExpress does not come with a GUI, so you end up having to use a different program like LinqPad or something to use for a GUI in order to run DDL statmeents like CREATE DATABASE/CREATE TABLE etc.

You should have them install the Express Version with Advanced Services; that includes the Express version of SQL Server Management Studio, so they can use that to run your DDL.

http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

AndrewSQLDBA SSC-Insane Points: 21829 More actions · Answer 4

You did not say if the flavor of database they have is Express. If not, then just use Enterprise Manager(SQL 2000) or SSMS(SQL 2005, 2008)

Do not install Express if they already have SQL Server running. Visio is not the best tool for creating a database. I use the Tools in SQL Server, or Erwin.

Andrew SQLDBA

philliard Newbie Points: 4 More actions · Answer 5

Thank you very much for such insightful answers! And they are not running the Express Version of SQL Server but have the full-blown installation.