[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Columnstore is not supported in this service tier

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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.