AdventureWorks Community Samples Databases for SQL Azure December 15, 2009

Introduction

Cloud computing on the Azure platform offers the opportunity to easily add more data and compute capacity on the fly as business needs vary over time. SQL Azure is the relational data store for the Azure platform. Although SQL Server and SQL Azure both communicate with clients via TDS, there are significant differences between what SQL Server supports and SQL Azure supports. So the familiar AdventureWorks community sample database scripts will not work if executed against SQL Azure without modification. This release provides the tools, data and scripts necessary to install the AdventureWorks data warehouse and the AdventureWorks Light (LT) databases into SQL Azure servers hosted in the cloud. Currently the AdventureWorks OLTP database is not supported for SQL Azure.

Prerequisites

In order to install the AdventureWorks community sample databases into SQL Azure servers you will need the following:

1. A SQL Azure project at http://sql.azure.com/.
2. Enough database quota to install one or both databases depending on your requirements. There is currently a limit of 150 databases per project which can be lifted with a credit check.
3. .NET Framework 3.5 which is available for free at MSDN.

SQL Server is not required in order to install the sample databases. However SQL Server Management Studio in the public CTP of SQL Server 2008R2 may be helpful for browsing and exploring SQL Azure databases. This CTP is located here.

Installation

If you have not already done so, download and extract the files from the zip file containing the AdventureWorks community sample databases for SQL Azure from CodePlex.

To install the SQL Azure version of the AdventureWorks data warehouse perform the following steps:

1. Delete any previous AdventureWorks data warehouse sample databases.
2. Start a command prompt window with Administrator privileges.
3. CD to the directory where the zip file was extracted.
4. CD to the AdventureWorks2008R2AZ\DW directory.
5. Type the following:

buildawdwaz.cmd tcp:servername username password

For example, if the assigned SQL Azure server is named b1gl33p, the administrator user name is Fred, and the password is Secret, the following would be typed:

buildawdwaz.cmd tcp:b1gl33p.database.windows.net Fred@b1gl33p Secret

The script will create the database, install the schema, and populate the database with sample data.


To install the SQL Azure version of the AdventureWorks Light (LT) sample database perform the following steps:

1. Delete any previous AdventureWorks Light (LT) sample databases.
2. Start a command prompt window with Administrator privileges.
3. CD to the directory where the zip file was extracted.
4. CD to the AdventureWorks2008R2AZ\LT directory.
5. Type the following:

buildawltaz.cmd tcp:servername username password

For example, if the assigned SQL Azure server is named b1gl33p, the administrator user name is Fred, and the password is Secret, the following would be typed:

buildawltaz.cmd tcp:b1gl33p.database.windows.net Fred@b1gl33p Secret

The script will create the database, install the schema, and populate the database with sample data.