LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 05-17-2010, 05:40 PM   #1
spider99
LQ Newbie
 
Registered: May 2010
Posts: 19

Rep: Reputation: 0
SQL database


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?

Last edited by spider99; 05-17-2010 at 05:44 PM.
 
Old 05-17-2010, 06:23 PM   #2
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
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
 
Old 05-17-2010, 06:32 PM   #3
spider99
LQ Newbie
 
Registered: May 2010
Posts: 19

Original Poster
Rep: Reputation: 0
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?
 
Old 05-17-2010, 06:53 PM   #4
rtmex
LQ Newbie
 
Registered: Apr 2007
Location: Puebla, Mexico
Distribution: Debian
Posts: 13

Rep: Reputation: 1
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Database Uses... Novatian Linux - Software 1 06-21-2008 02:18 PM
(my)sql: drop database doesn't remove database kpachopoulos Programming 3 09-19-2007 02:32 PM
TOMCAT and MS SQL database shane200_ Programming 0 05-31-2005 11:52 AM
database needed not sql herc222 Linux - Software 3 03-08-2004 08:34 AM
SQL Database Administration GabeF Linux - Software 2 11-17-2002 08:28 PM


All times are GMT -5. The time now is 08:00 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration