Monday 26 January 2009

SQL 2008 : Scripting All Database Objects

Unchanged from SQL 2005, but I've never has cause to reverse generate files for a source code repository before...

1) Right click database > Tasks > Generate Scripts >


2) Wizard front screen >


3) Select Database >


4) Script Options (defaults left here) >


5) Output file options.

Note the 'File per object' button I've selected here >


6) Summary screen (review options if you wish, then click next) >


7) Watch progress (or get a coffee if the db is a large one) >


8) The output! A folder full of files!

No comments: