complete sql installation on ubuntu

XYZ 1 Reputation point
2023-01-05T15:00:48.227+00:00

good evening
sorry for my beginner level and for my english (i'm italian)
I would like to install full sql on ubuntu
I mean not only the server side, but also the management studio and the graphical database management environment.
To explain myself better, I installed sql management studio on windows and I had all this.
I remember that it could also be done on ubuntu some time ago, but now I only see guides for installing the server side on ubuntu to which you can then connect with management studio from windows, while I did and would like to do everything on ubuntu.
The ubuntu version doesn't matter, rather I would need to install it persistently on a stick, I don't know if that changes anything
thank you

SQL Server Other
{count} votes

4 answers

Sort by: Most helpful
  1. Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator
    2023-01-05T16:20:53.643+00:00

    Sql server management studio does not support Linux. You can install azure data studio

    https://azure.microsoft.com/en-us/products/data-studio/

    And if you need command line tools

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

    Note: unlike windows they are separate installs.

    0 comments No comments

  2. Olaf Helper 47,436 Reputation points
    2023-01-06T06:12:42.973+00:00

    but also the management studio

    As Bruce wrote, SSMS is a Windows tool and not supported on Linux.

    But instead you can use the newer tool Azure Data Studio, supported on Win, Linux and Mac, it also supports other RDBMS like MySQL etc.
    Download and install Azure Data Studio

    0 comments No comments

  3. Seeya Xi-MSFT 16,586 Reputation points
    2023-01-06T06:46:54.947+00:00

    Hi @XYZ ,

    Because there really isn't a lot of documentation on installing SQL Server on Linux systems, you can refer to this video:
    https://www.youtube.com/watch?v=eWzzsPdaHVs
    Also, you can read this article: https://www.sqlshack.com/how-to-install-sql-server-on-ubuntu/
    I don't have a Linux environment myself, so I may not be able to go through such an installation all over again. But I agree with what they say about installing ADS instead of SSMS.

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.