In the meantime, going back to SQL Server Management Studio, right click on the database AdventureWorksDW2014, then Tasks and then click on Deploy Database to Windows Azure SQL Database.: SqlSamplesSourceDataPath: path of the extracted zip-fileĪctivate cmd-mode (otherwise running the script will result in errors):īefore you deploy the newly created database AdventureWorksDW2014 to Azure, you first need to create an Azure SQL Database:.SqlSamplesDatabasePath: path where you want to build your databases.Open instawdbdw.sql in the extracted zip-file in SQL Server Management Studio.īefore you execute the SQL-file, change the directories accordingly:
Build Adventure Works 2014 Warehouse Locally When clicking on the start button, click on the arrow down to select the SQL Server 2014 Management Studio from the list of apps (since it is already convienently installed :) ):ĭownload the zip-file Adventure Works 2014 Warehouse Script.zip from the AdventureWorks CodePlex site and extract it.ģ. Once the VM is created, connect to it (for instance using the Remote Desktop Connection Manager): When creating my VM, I left the defaults as provided: To spare my laptop from more and more programs, I decided to set up my SQL VM - a VM provided in the Azure portal that already has SQL Server 2014 Enterprise installed on Windows Server 2012 R2: Have SQL Server 2014 installed - either local or in a SQL Server VM in Azure AdventureWorks 2014 Warehouse), these are the steps to follow: 1. However, if you want to use other versions of the AdventureWorks dataset (like here in this case, i.e.
If you only want to use the AdventureWorks Lightweight database, this is easily done using the new Azure portal thanks to its integration: For a machine learning experiment (in AzureML) I wanted to make use of that dataset - best to have it uploaded in an Azure SQL Database.
Home Subscribe How to Set Up the Adventure Works 2014 Warehouse in Azure SQL Database 25 August 2015 on Azure SQL Database, Azure SQL DB, AdventureWorks, Migrate, Step-by-StepĪdventureWorks is probably the most famous and openly available dataset any SQL-DBA can think of. Home Automation mit dem Microsoft Ökosystem (German).