AdventureWorks Database For SQL Azure

In this article we will walk through step-by-step to create an AdventureWorks database for SQL Azure. We will use an AdventureWorks database for SQL Azure from Codeplex. To create it use the following instructions.

Step 1

Go to http://msftdbprodsamples.codeplex.com/ 

Step 2

Download SQL Azure OLTP from the Codepex site; see:



Step 3

After downloading, unzip the file into a folder. After unzipping the file open a command prompt and change the directory to the unzipped folder. I have unzipped the file in the folder named SQLAzurePortal.



Step 4

Cross-check that your machine IP address is in the range of the firewall rules.




Step 5

Run the command as in the following:



In case you are wondering what your SQL Azure Server name is, you can check that as in the following. Log in to the SQL Azure portal and in the right panel you can obtain information about username and server name; see:



Your command should be as in the following:



After successful installation with data in SQL Azure, you should get the following success message:



Now to verify that the AdventureWorks database was installed successfully, open SQL Azure portal and in the database you should see that the database has been listed there, as in:



In this way you have successfully installed AdventureWorks database on SQL Azure. I hope this article was useful. Thanks for reading