Columnstore is not supported in this service tier.

Applies to: SQL Azure Database V12.
 

Problem Description.
 

Trying to deploy a database to Microsoft SQL Azure using SQL Server Management Studio a user received the following error message:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Could not import package.
Warning SQL0: A project which specifies SQL Server 2016 as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12.
Error SQL72014: .Net SqlClient Data Provider: Msg 40536, Level 16, State 32, Line 5 'COLUMNSTORE' is not supported in this service tier of the database. See Books Online for more details on feature support in different service tiers of Windows Azure SQL Database.
Error SQL72045: Script execution error. The executed script:
CREATE CLUSTERED INDEX [CCX_Fact_Movement]
ON [Fact].[Movement]([Movement Key])
ON [PS_Date] ([Date Key]);

CREATE CLUSTERED COLUMNSTORE INDEX [CCX_Fact_Movement]
ON [Fact].[Movement] WITH (DROP_EXISTING = ON)
ON [PS_Date] ([Date Key]);

(Microsoft.SqlServer.Dac)

Cause.

A note at the beginning of this article says that columnstore is a Premium feature.

"For Azure SQL Database, columnstore indexes are only available in Premium Edition."

Solutions/Workarounds.


The user needs to scale the target SQL Azure database to any of available Premium tiers or avoid using columnstore indexes.

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.