Navigate

21 Missing Features in SQL Server on Linux

In last tip, I have explained about new features introduced in SQL Server 2017. SQL Server support on Linux based operating systems is one of the new feature introduced in SQL Server 2017. Here, I will describe all those missing features from Linux based SQL Server instances but these features can be used if you are deploying your SQL Server on Windows operating system. We are expecting Microsoft will include all these features in upcoming releases of SQL Servers.

Missing Features in SQL Server on Linux

Below is the list of features that are not supported on Linux based SQL Server instances as of now in current GA release of SQL Server 2017.

1. Analysis Services
2. Reporting Services
3. R Services
4. Master Data Services
5. Data Quality Services
6. SQL Server Browser Service
7. Transactional & Merge Replication
8. FILESTREAM
9. FileTables
10. Stretch DB
11. Polybase
12. Third Party Extensions
13. XPs
14. VSS Snapshots
15. Buffer Pool Extension
16. Change Data Capture
17. Alerts
18. Distributed query with 3rd-party connections
19. Database Mirroring
20. AD Authentication for Linked Servers & Availability Groups (AGs)
21. SQL Server Integration Services (SSIS)

The mssql-server-is package (SSIS) is not supported on SUSE Linux in this release. It is currently supported on Ubuntu and on Red Hat Enterprise Linux (RHEL) only.

The following features are not supported in this release when you run SSIS packages on Linux:

o SSIS Catalog database
o Scheduled package execution by SQL Agent
o Windows Authentication
o Third-party components
o Change Data Capture (CDC)
o SSIS Scale Out
o Azure Feature Pack for SSIS
o Hadoop and HDFS support
o Microsoft Connector for SAP BW

For a list of built-in SSIS components that are not currently supported, or that are supported with limitations, see Limitations and known issues for SSIS on Linux

Related Articles:

I hope you like this article. Please follow us on our facebook page and on Twitter handle to get latest updates.

Follow me:
Latest posts by Manvendra Deo Singh (see all)
Interview QuestionsLinuxMissing featuresRHELSQL Server On Linux
Manvendra Deo Singh: I am working as a Technical Architect in one of the top IT consulting firm. I have expertise on all versions of SQL Server since SQL Server 2000. I have lead multiple SQL Server projects like consolidation, upgrades, migrations, HA & DR. I love to share my knowledge. You can contact me on my social accounts for any consulting work.

View Comments (2)

  • Hi,

    Were there any major changes since the article was written? We are in the process of evaluating missing features in 2017.

    • NO, I don't see any major changes in SQL Server 2017 since this article was published. For latest updates you can visit Microsoft website attached in the first paragraph of this article.

Leave a Comment
Related Post
  1. How to Change Hostname of RedHat Linux Server

    Last week we had received some requests to rename or change hostname of RedHat Linux…

  2. How to Create Virtual Machine on your PC?

    Are you struggling to setup a server lab for your requirement? We can create multiple…

  3. Fix PuTTY Network Error: Connection Refused while Connecting to Ubuntu Server

    I installed SQL Server 2017 on Ubuntu server and tried to connect to this server…

  4. How to Find and Change IP Address, Subnet Mask & Default Gateway of Linux Server

    Sometimes we need to check the IP, Subnet mask and default gateway of our Linux…

  5. How to Use CAT Command on Linux System?

    This time we continue with the explanation of simple Linux command to learn basics. The…

Leave a Comment

Interview Questions & Answers

Latest Articles

Categories