Well, I don't know if it is a valid question or not but, I need to install three SQL Server services on my laptop namely: Analysis services, Integration services, and Reporting services. Windows installer offers an option to install these services through SSDT
Still after a lot of searching, I couldn't find any solution. I have already installed SQL Server 2017 on my Ubuntu machine, but now I need your help for installing these services :)
3 Answers
Here's an article[1] that describes it with docker... Specifically it downloads a linux version of the tools[2] to extract into the container... should work with Ubuntu directly.
wget -progress=bar:force -q -O sqlpackage.zip \ \ && unzip -qq sqlpackage.zip -d /opt/sqlpackage \ && chmod +x /opt/sqlpackage/sqlpackage \ && rm sqlpackage.zipNo. These are Windows tools to be used on a Windows machine.
From Microsoft docs:
Use existing SQL tools on Windows with SQL Server on Linux
Tools that currently run on Windows such as SSMS, SSDT, and PowerShell, also work with SQL Server 2017 on Linux. Although they do not run natively on Linux, you can still manage remote SQL Server instances on Linux.
See the following topics for more information:
so ...
Still after a lot of searching, I couldn't find any solution. I have already installed SQL Server 2017 on my Ubuntu machine, but now I need your help for installing these services :)
You need a Windows machine; if that was not the case you would be able to use their tools without any connection to Microsoft.
Possible method: install virtualbox in your Ubuntu desktop, Windows in there and the tools in there and then connect to your SQL server.
1I installed yesterday Visual Studio Code for linux on Ubuntu 18.10 after having installed SQL Server 2017. It looks very interesting as support a lot of different languages. By the way, I'm trying to connect with the DB, still without success!
1
