1
votes

I've made a Database-Project, which was originally supposed to be deployed to an SQL Server Enterprise Edition 2014. Some Tables in the project have Clustered Columnstore Indices. As far as I know, Clustered Columnstore Indices are not supported in SQL Server Standard Edition 2014.

My question is: What will happen if someone tries to deploy this database project with CCIs to a Standard Edition? Will the tables still be created, but without the Indices or will the whole project deployment fail?

Unfortunately, I can't test this by myself because I only have the Developer-Version of SQL Server, which includes all Enterprise Features.

1
Presumably they would get an error that the column store indexes are not supported. However, it might depend on the deployment mechanism.Gordon Linoff

1 Answers

0
votes

As Gordon suggested above it all depends on the deployment mechanism, but there's a very high chance it'll fail (as it should IMO). Moreso if the deployment is handled within a Transaction that will be rolled back in the event of a failure.

Few deployment systems will go the extra mile to ascertain what functionality is supported by the destination RDBMS and most should follow the rule of 'This is in my code repository, deploy it'. To allow it to do otherwise could introduce breaking changes.

TBH your best bet is to keep two branches of the codeset in your source repository - one with the xVelocity indexes, one without. Either that or deploy first to a Developer instance, then run a script to strip out the Enterprise features you know about then script those changes out to deploy to a downstream SKU.

Yes, that is more work and will require regular code merges with changes, or work creating the downstream code. but it will at least allow you to deploy from a well defined codeset.

If you absolutely must deploy from an Enterprise derived script then you're going to be looking at rolling your own deployment script.

As an aside (and not that it will help you with 2014), as from Sql Server 2016 SP1, Microsoft changed the playing field and allowed 99% of Enterprise functionality in all all SKUs - this includes the CCI's