February 14, 2012
Cloud computing on the Windows 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 AdventureWorks2012 and the AdventureWorks2012_Federation databases into SQL Azure servers hosted in the cloud.
In order to install the AdventureWorks community sample databases into SQL Azure servers you will need the following:
1. A SQL Azure server at http://sql.azure.com/.
2. Enough database quota to install one or both databases depending on your requirements. For SQL Azure you are allowed to create a maximum of 5 databases per project.
3. .NET Framework 4.0 which is available for free at http://msdn.microsoft.com/en-us/netframework/aa569263.aspx.
4. Ensure that you have configured your SQL Azure Firewall to allow
a connection to your SQL Azure server from your IP address.
SQL Server is not required in order to install the sample databases. However SQL Server Management Studio in SQL Server 2008R2 may be helpful for browsing and exploring SQL Azure databases.
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 http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=37304.
To install the SQL Azure version of the AdventureWorks2012 database for SQL Azure perform the following steps:
1. Delete any previous AdventureWorks2012 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 AdventureWorks\ directory.
5. Type the following:
CreateAdventureWorksForSQLAzure.cmd 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:
CreateAdventureWorksForSQLAzure.cmd 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 Federated version of the AdventureWorks2012 sample database perform the following steps:
1. Delete any previous AdventureWorks2012_Fed 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 AdventureWorks_Federated\ directory.
5. Type the following:
CreateAdventureWorksForSQLAzure_Fed.cmd 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:
CreateAdventureWorksForSQLAzure_Fed.cmd b1gl33p.database.windows.net Fred@b1gl33p Secret
The script will create the database, create a Customer Federation, install the schema, and populate the database with sample data.