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:
Post a Comment