LinuxQuestions.org - SQL database

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - SQL database (https://www.linuxquestions.org/questions/linux-newbie-8/sql-database-808429/)

Got a few questions, hoping someone can answer

1. In a Windows platform to host a database i have Microsoft SQL server but wish to move over to Linux so which software can i use to hold a database on a Linux platform (CentOS)?

2. In Windows i'm using ODBC connections, does Linux have those if so then where do i go to setup and if not then is there anything similar to ODBC in linux that also links with the SQL server?

Hi -

Quote:

Q: In a Windows platform to host a database i have Microsoft SQL server but wish to move over to Linux so which software can i use to hold a database on a Linux platform (CentOS)?

A: You have many choices of databases that run under Linux, including DB2, Oracle, Postgress and (perhaps most popular) MySQL.

You also have the option of continuing to use your SQL Server database, and accessing it remotely from Linux.

Quote:

In Windows i'm using ODBC connections, does Linux have those if so then where do i go to setup and if not then is there anything similar to ODBC in linux that also links with the SQL server?

Yes: all of the databases I mentioned above run on Linux, and fully support ODBC. Linux also supports native drivers.

'Hope that helps .. PSM

Quote:

A: You have many choices of databases that run under Linux, including DB2, Oracle, Postgress and (perhaps most popular) MySQL.

I must be able to use a MSSQL server db, is it however still possible on those you've listed?

You can't install a MSSQL server db on a GNU/Linux box. You will have to migrate your MSSQL server to a database server that can be installed on GNU/Linux (as paulsm4 have already told you, PostgreSQL, MySQL, FireBird, etc.)
By the way all the databases I have listed are so much better RDBMS than MSSQL server