CODEWITHSUNDEEP
sql-serverazure
user5767413
user5767413

Reputation: 177

How to get latest SQL Server version when creating Azure SQL database

I believed that I always got the latest version of SQL Server when creating a new Azure database from the Azure Portal. But that is not happening.

I always get sql Server version (12.0.2000.8) which is SQL 2014. I can't find other places to set a new compability level either.

Is there a problem with my subscription (pay as you go)??

Have any of you had the same experience as me, have you been able to solve it?

The reason I want SQL 2017 is that I want to publish SSIS packages to the SSISDB catalog, which is not possible on SQL 2014?

Hope any of you can help me out here

regards GEir

Upvotes: 4

Views: 7442

Answers (1)

Mladen
Mladen

Reputation: 199

It's possible to use SSIS on DB engine 12 on Azure. Check out official documentation.

Additionally, you may upgrade your already-created azure databases by setting COMPATIBILITY_LEVEL modificator. Look into ALTER_TABLE documentation for examples.

Please note that although SQL Azure's engine share similar "engine api" as SQL Server 2014 (v12), those are not the same. What's more relevant in terms of supported features is maximum supported "Compatibility level".

Upvotes: 1

Related Questions