4

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

Improve this question
3
  • SSISDB (specifically the SSIS Project Deployment method) was introduced in SQL Server 2012. It is available in SQL Server 2014. Commented Nov 26, 2018 at 23:26
  • Microsoft's FAQ confirms V12 is the current version in Azure. This article claims you do need version 17.2 or later of SQL Server Management Studio; I see no similar requirement for the server instance. So you may be good to go. Commented Nov 26, 2018 at 23:29
  • There is no problem with your version or with publishing packages to SSISDB. What is specifically stopping you creating an SSISDB right now using the normal methods? Keep in mind that to use an SSISDB in SQL Azure, it probably makes sense to use Azure Data Factory v2 which hosts and executes packages in the cloud. Commented Nov 27, 2018 at 0:59

1 Answer 1

Reset to default
1

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".

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.