Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

622


Part V: Enterprise Data Management


The Set Scripting Options screen, as shown in Figure 23-4, contains several options for saving
the script. You can either save the scripts to a location of your choice or publish the objects
directly to a remote web hosting provider. In order to be able to publish to a web service, you
must have access to that service via the Database Publishing Services Web service.

In addition to saving to custom locations, you are given other options, such as generating
a single script fi le for all objects or generating a script fi le per object. You can also choose
to either save the generated script directly to the Windows clipboard or save to a new query
window in SSMS.

FIGURE 23-4
Select your options for how your script should be saved or published.

c23.indd 622c23.indd 622 7/31/2012 9:25:21 AM7/31/2012 9:25:21 AM


http://www.it-ebooks.info
Free download pdf