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.
Asked
Active
Viewed 8,806 times
4 Answers
4
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.
John Emeres
- 473
- 5
- 6
2
Saw Austin Solonen post this tool in a somewhat related thread. Express editions appearantly don't hove Import and Export.
Community
- 1
- 1
Martijn Laarman
- 13,476
- 44
- 63
-
Thank you, this deserves the "answer" flag as well! – Mark Brittingham Jan 08 '09 at 03:30
2
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
- 28,894
- 13
- 84
- 111
-
Non Express versions of the manager have been able to since SQL2000 ;) – Martijn Laarman Jan 07 '09 at 23:14
2
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
- 31,785
- 25
- 82
- 101
-
Wow, step away mid-response to go to the bathroom and look how badly you get beaten! – Portman Jan 07 '09 at 23:08
-
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 Jan 08 '09 at 03:31