Forum Discussion

CaldeiraG's avatar
CaldeiraG
Copper Contributor
May 11, 2022

ODBC drivers for Ubuntu 22.04

I recently installed Lubuntu 22.04 and following these https://docs.microsoft.com/it-it/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15#ubuntu18 t...
Ronen_Ariely's avatar
Ronen_Ariely
MVP
Mar 26, 2023

Hi CaldeiraG , all

Option 1: According to Microsoft documentation it is well supported.

> In this quickstart, you install SQL Server 2022 (16.x) on Ubuntu 20.04.

 

Please follow this document:

https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver16&WT.mc_id=DP-MVP-5001699

 

 

Option 2: You can install Docker into Ubuntu 22.04.

(1) Install Docker Engine on Ubuntu:

https://docs.docker.com/engine/install/ubuntu/#set-up-the-repository

(2) Install SQL Server Container:

https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash

 

steve60's avatar
steve60
Copper Contributor
Mar 27, 2023

Ronen_Ariely 

 

Already in the process of switching all our clients to PostgreSQL. It is way cheaper as well. 

 

 

  • Ronen_Ariely's avatar
    Ronen_Ariely
    MVP
    Mar 27, 2023

    cheaper will be to use notepad :happyface:

    "cheaper" is just one parameter to take into consideration out of of tens of parameters, but we cannot know what best fit your needs, only you should know. Good luck with any decision to got.

    • steve60's avatar
      steve60
      Copper Contributor
      Mar 27, 2023
      postgresSQL is a well balanced and well known database. With out understand our company needs and how we are using it makes it difficult for you to comment on in intelligently.
      If we are using only 50% of the capabilities of MS SQL and PostgresSQL can do everything we need but is 1/2 the price to get the servers running then yes it is Cheaper. and it will do everything we need it to.
      • Ronen_Ariely's avatar
        Ronen_Ariely
        MVP
        May 16, 2023

        Hi steve60 

         

        > postgresSQL is a well balanced and well known database.

         

        You are totally current. It is a great database server which can fit most cases. My last response was not related to this specific solution but just noted about the reason you mentioned "cheaper". I just wanted to emphasize that cheaper is just one parameter when you select the solution.

         

        I am sure your will have an awesome system

         

        Have a great day

         

Resources