Migrating Databases and Data to SQL Azure (part 2)

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.

On 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.