CODEWITHSUNDEEP
sql-serverddl
Mark Brittingham
Mark Brittingham

Reputation: 28865

Tools to generate SQL DDL and Content from an existing database

Does anyone know of a reasonably priced tool that will create DDL statements to create a SQL Server database and appropriate Insert statements to recreate the data? I use the Red Gate tools to do database compares (including content compares) and this comes close (I could always compare with an empty schema) but I was wondering if there was a tool that others found useful that did this in one step.

Upvotes: 2

Views: 9136

Answers (4)

John Emeres
John Emeres

Reputation: 473

Late answer... hopefully someone will find it useful…

There is a tool from Red Gate called SQL Multi Script that can do scripting for what you need. Not sure if it existed when the question was asked though :)

Another good piece is SQL build tool from ApexSQL which can also do all kind of insert and other scripts…

Disclaimer: I’m not affiliated with any of the companies mentioned above.

Upvotes: 4

Portman
Portman

Reputation: 31975

The database publishing wizard that is included in Visual Studio 2008 performs this function.

It is also available via CodePlex as an add-on for prior versions of Visual Studio.

Upvotes: 2

Ray Booysen
Ray Booysen

Reputation: 30031

Have you had a look at SQL Publishing Wizard? It will create all the DDL statements you require for all database elements (tables, views, SPs, users etc).

If you're using SQL 2008, it comes built into the management studio. More info on 2008.

Upvotes: 2

Martijn Laarman
Martijn Laarman

Reputation: 13536

SQL Publishing Wizard

Saw Austin Solonen post this tool in a somewhat related thread. Express editions appearantly don't hove Import and Export.

Upvotes: 2

Related Questions