AdventureWorks Community Samples Databases for Azure SQL Database
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. Azure SQL Database is the relational data store for the Windows Azure platform. Although SQL Server and Azure SQL Database both communicate with clients via TDS, there are significant differences between SQL Server and Azure SQL Database. So the familiar AdventureWorks community sample database scripts will not work if executed against Azure SQL Database without modification.
In order to install the AdventureWorks community sample databases into an Azure SQL Database server you will need the following:
- An Azure SQL Database server at https://www.windowsazure.com/en-us/pricing/free-trial/.
- .NET Framework 4.0 which is available for free at MSDN.
- Ensure that you have configured your Azure SQL Database Firewall to allow a connection to your Azure SQL Database server from your IP address.
SQL Server is not
required in order to install the sample databases. However SQL Server Management Studio of SQL Server 2012 may be helpful for browsing and exploring Azure SQL databases.
If you have not already done so, download and extract the files from the zip file containing the AdventureWorks community sample databases for Azure SQL Database from CodePlex
To install the Azure SQL Database version of the AdventureWorks2012 database:
CreateAdventureWorksForSQLAzure.cmd servername username password
- Delete a previous AdventureWorks2012 sample database.
- Start a command prompt window with Administrator privileges.
- CD to the directory where the zip file was extracted.
- CD to the AdventureWorks\ directory.
- At the command prompt:
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.