Deploying To Azure SQL Database

Kevin Feasel

2016-05-16

Cloud

Julie Smith shows how to deploy a database (AdventureWorksDW) out to Azure:

This is telling us that four of the tables in the sample do not have clustered indexes. Azure SQL Database insists on a clustered index for every table. So without warranty, here is a script that I used to refactor my on-prem AdventureWorksDW2014 database. After making these fixes, I was able to deploy to Azure SQL DB from SSMS with no errors.

Julie includes the script she used to fix up AdventureWorksDW.

Related Posts

Scala + Hadoop + HDInsight

Emmanouil Gkatziouras shows that you can run a Hadoop job written in Scala on Azure’s HDInsight: Previously, we set up a Scala application in order to execute a simple word count on Hadoop. What comes next is uploading our application to HDInsight. So, we shall proceed in creating a Hadoop cluster on HDInsight. Read the […]

Read More

Azure Elastic Pools

Derik Hammer explains what Azure SQL Database Elastic Pools do: Azure SQL Database Elastic Pools are a mechanism for grouping your Azure SQL Databases together into a shared resource pool. Imagine for a moment that you had a physical server on premise. On that server, you have a single SQL Server instance and a single […]

Read More

Categories

May 2016
MTWTFSS
« Apr Jun »
 1
2345678
9101112131415
16171819202122
23242526272829
3031