However, nothing feels more comfortable to a developer than something that familiar. After a little bit of investigating while preparing for my talk at Confoo on SQL Azure, I managed to find a post on the MSDN website that Explains what is needed in order to use the Generate Scripts Wizard in SQL Server Management Studio.

Create the Transact-SQL Script

In ObjectExplorer, right-click the database, point to Tasks, and select GenerateScripts.

In the ScriptWizard dialog box, click Next to get to the SelectDatabase step. Select School, select Script all objects in the selected database, and then click Next.

In ChooseScriptOptions, set the following options:

Convert UDDTs to Base Types = True

Script Extended Properties = False

Script Logins = False

Script USE DATABASE = False

Script Data = True

SQL Azure does not support user-defined data types, extended properties, Windows authentication, or the USE statement.

Click Next, click Next, and then click Finish. The Script Wizard generates the script. Click Close when the script is completed.

Each CREATE TABLE statement includes the "ON [PRIMARY]" clause. Delete all instances of that clause.

The reason you need to apply these changes to the script is that SQL Azure currently doesn’t support all the features of the currently release of SQL Server 2008. There are plans to start to incorporate some of the features that are in this outline, including the USE statement.

Hopefully this will make your life easier on your move to the cloud. Until then, Happy Coding!