Thursday, March 3, 2011

SQL Server: Multiple Objects Script but Save Each to Separate Files

Recently a developer asked for a tool or script which can generate script for given objects (tables, views, stored procedures etc) but results should be saved in separate files.
I think they were not aware that SQL Server 2008 already added this facility in script Wizard. Once you have provided all your required options and reached on last page of script wizard. This page provides options that you can save output to a single file or separate files, one for each object.

1 comment:

All suggestions are welcome