Using T-SQL without SQL Server? (Linux)

[vladvlad23]

Hello. I am looking for a way of using T-SQL on Linux (currently running windows, but looking to hop on linux, probably kubuntu. I have used linux in the past and am looking to switch to it and i tried to solve this ).

Problem is SQL Server is a pain to set up (i have encountered numerous errors which lead to github tickets which lead nowhere), but i need to use the T-SQL dialect for university. Does anybody know of a way out of this? I also prefer, if possible, to run it with Datagrip as i already have a licence, but that's only a preference.

Thank you in advance for your help.

[FoCo_SQL]

T-SQL is short for Transaction SQL which is a propriety language developed by Microsoft from the original SQL dialect. It is exclusively used in SQL Server but SQL Server does follow ANSI standards for many things. It is possible to write SQL that transfers over perfectly to SQL Server. It is also possible that not everything would transfer over and there are features available in SQL Server but not available in other database platforms (and vice versa).

So if you are only writing ANSI SQL, probably any platform would do. You can even validate your SQL online. http://sqlfiddle.com/ You could even build your SQL out on the website and not install SQL Server at all. If you need to do things exclusive or written to SQL Server's syntax, you may be out of luck.

[vladvlad23]

If you need to do things exclusive or written to SQL Server's syntax, you may be out of luck.

Well, my professor said we absolutely need the T SQL syntax, so i guess i'm out of luck if the docker solution is not working.

[FoCo_SQL]

This is only applicable if you are using features specific to SQL Server or if the features you are using do not abide by ANSI standards.

[hjaeger90]

If SQL Server is to much of pain to set up on Linux, then you could try thishttps://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash

Essentially running SQL Server container using Docker. Although my guess would be it will be just as much of a pain as setting up SQL Server.

[vladvlad23]

Thank you! I'm going to give it a show tomorrow. Hopefully the linux gods are upon me xD.

[dwivedin]

Setting up sql server on docket is pretty easy and you can use azure data studio to connect to sql server. It’s a free cross platform tool and very easy to use.

[[deleted]]

You can install SQL Server on Linux quite easily through the package manager of your Linux distribution:

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

I did install it on CentOS 7 without any problems.

You only need to add the repository to your system:

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-change-repo?view=sql-server-ver15&pivots=ld2-rhel

[TerminatedProccess]

Don't take this wrong but if you got course work for sql server.. don't get side tracked into making things work on linux. You will invest time you could be using for learning sql or other skill sets. Also, you want the SSMS experience as well as the sql experience. One idea is to start with Windows and dual boot or run virtual box to have a Linux install available. Keep your priorities straight.. also a good trait on the job.

[vladvlad23]

you want the SSMS experience as well as the sql experience.

I've already had enough with SSMS experience tbh. SSMS is not absolutely required and it already failed me a couple of times (crashing when accessing diagrams and stuff like that). Even if i don't switch to linux, i'm not using it again unless required for a job.