Forum Discussion

Prakash07's avatar
Prakash07
Copper Contributor
Nov 11, 2019

SQL server 2016 with Integration services on Ubuntu

Hi everyone,

I need to setup SQL server 2016 on Ubuntu with Integration Services. Is it feasible to install SSIS with SQL server 2016 on Ubuntu for Prod use?

If i go to Microsoft documentation,they only showing  SQL 2017 and 2019 for Linux. Can anyone help with any related resources for clarification w.r.t SQL 2016?

 

Thanks in advance 

Prakash

 

2 Replies

  • Russean's avatar
    Russean
    Iron Contributor

    SQL Server 2016 is not supported on Linux—only SQL Server 2017 and later. SSIS also isn’t natively available on Linux; you’d need Windows for full support. For production, use SQL 2017/2019 on Linux or keep SQL 2016 + SSIS on Windows.

  • Hi Prakash07​ 

    SQL Server 2016 and SSIS aren't supported on Linux and you need to upgrade to 2017+ or stick with Windows for production use.

    https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-ver17

Resources