1.3. Setting Advanced Options
Clicking the Advanced button brings up the Advanced Scripting Options dialog shown in Figure 3. Follow these steps:
In the Advanced Scripting Options dialog, set the following options:
Convert UDDTs to Base Types = True
Script Extended Properties = False
Script Logins = False
Script USE DATABASE = False
Types of data to script = Schema and data
Figure 3. Advanced Scripting Options dialog
You can also set the Script DROP and CREATE option to Script DROP and CREATE, as shown in Figure 3, but that option isn't required for SQL Azure.
Click OK in the Advanced Scripting Options dialog, and then click Next in the Generate Scripts wizard.
1.4. Saving and Publishing
Complete the wizard with these steps:
the wizard's Summary page, review your selections, and then click Next.
The T-SQL script is generated, and you're taken to the Save or Publish
Scripts page (see Figure 4).
Figure 4. Completed Scripted Process
Click Finish. At this point your script is finished and is displayed in a query window in SSMS.