This article is a step-by-step walkthrough of how to create an AdventureWorks database for SQL Azure. We will use the AdventureWorks database for SQL Azure from codeplex. To create it use the following steps.
Step 1
Go to http://msftdbprodsamples.codeplex.com/
Step 2
Download SQL Azure OLTP from the codeplex site:
Step 3
After downloading, unzip the file to a folder. After unzipping the file, open the command prompt and change the directory to the unzipped folder. I have unzipped the file to a folder named SQLAzurePortal.
Step 4
Ensure that your machine IP address is within the range of the firewall rules.
Step 5
Run the command as in the following:
In case you wonder what your SQL Azure Server name is, you can check that as in the following. Login to the SQL Azure portal and in the right panel you can get information about the username and server name:
Your command should be as follows:
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 the SQL Azure portal and in the database you should able to see that the database has been listed there:
In this way you have successfully installed the AdventureWorks database in SQL Azure. I hope this article was useful. Thanks for reading.