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.
+1
A:
Saw Austin Solonen post this tool in a somewhat related thread. Express editions appearantly don't hove Import and Export.
Martijn Laarman
2009-01-07 23:01:45
Thank you, this deserves the "answer" flag as well!
Mark Brittingham
2009-01-08 03:30:13
+2
A:
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.
Ray Booysen
2009-01-07 23:03:04
Non Express versions of the manager have been able to since SQL2000 ;)
Martijn Laarman
2009-01-07 23:14:47
+1
A:
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.
Portman
2009-01-07 23:08:00
Wow, step away mid-response to go to the bathroom and look how badly you get beaten!
Portman
2009-01-07 23:08:33
Thanks anyway Portman. It does seem like answers fly quickly on SO. Good answer though...I voted you up for being right anyway.
Mark Brittingham
2009-01-08 03:31:03