623
Chapter 23: Transferring Databases
23
If you wish to have more granular options for your generated scripts, you can click the
Advanced button to display the Advanced Scripting Options screen as shown in Figure 23-5.
From there you specify advanced options, such as generating a script aimed at a specifi c
version of SQL Server (which causes the scripted out options to be compatible with the
selected target version), check for existing objects’ existence, script for dependent objects,
and much more.FIGURE 23-5
Advanced Scripting Options.The Summary screen shows a summary of choices that were made so far. If you want to
change something, you can click Previous and modify your selections. If you are satisfi ed
with all the choices, click Next. Once you have clicked Next, the wizard will generate the
scripts according to the options you selected. The Save or Publish Scripts screen shows a
detailed breakdown of the status of each step of the process, as shown in Figure 23-6. If
there are any errors, or if you simply wish to save results, you can click Save Report to save
the output to HTML and review the report. Click Finish to complete the process.c23.indd 623c23.indd 623 7/31/2012 9:25:21 AM7/31/2012 9:25:21 AM
http://www.it-ebooks.info