LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 11-23-2003, 05:57 AM   #1
duaux
Member
 
Registered: Mar 2002
Location: Toronto, Canada
Distribution: RH 9, Gentoo 1.4: Fluxbox!!!
Posts: 96

Rep: Reputation: 15
Question Curious Student needs help. Which SQL to run?


sorry for the newbie question.

but i am interested in knowing which SQL program i can use that is most compatible with

MS SQL server...

im not running anything... "important" in terms of a critical servers...

im just a student thats taking a intro database class, and they just happen to use MS SQL Server.

thus i would like to "learn" the equivalent of it on the *NIX side...

(My SQL, Postgre, DB2, Oracle? etc...)

the important aspects im looking for similar (or exact) like MS SQL Server:
===================================================

- SQL Query Analyzer... (where i can input CODE, and then just run it... displaying tables, etc.)
- perferbly GUI interface...but console is not a problem
- enterprise manager, where i can access, create databases

Any comments appreciated.

thank you.
 
Old 11-23-2003, 06:20 AM   #2
scott_R
Member
 
Registered: Jul 2003
Location: Brighton, Michigan, USA
Distribution: Lots of distros in the past, now Linux Mint
Posts: 746

Rep: Reputation: 31
Well, not to dissuade you but most SQL DB's aren't "standard". What I mean is that you're going to have to unlearn a lot of things to move from one to the other. This holds true for commercial and OSS DBs, mostly because there is no good SQL standard. Because of the tug of war between players, SQL is more of a misnomer than a standard. However, once you learn SQL fairly well, your knowledge should translate to other DBs reasonably easily.

I'd recommend looking at MYSQL, Postgre, IBM's DB2 and Oracle as the better ones, depending on your needs. None is perfect, but they tend to work with each other a whole lot better than MS's implementation does. Not that it's terrible, because it is used alot, but you'll make more money learning the other's versus MS's "mom and pop easy" DB.

I use Mysql, partialy because it's OSS, but also because it hooks into almost every programming language out there.

Last edited by scott_R; 11-23-2003 at 06:23 AM.
 
Old 11-23-2003, 12:31 PM   #3
Covel
Member
 
Registered: Oct 2003
Location: Portugal
Distribution: Gentoo
Posts: 116

Rep: Reputation: 16
I recommend not going with MySQL because it's very incomplete and you'll find you can't do some things you learn in class.

I use MySQL for my website and projects but (beeing also a student having database classes) I know it isn't enough for some learning examples.
 
Old 11-23-2003, 02:05 PM   #4
duaux
Member
 
Registered: Mar 2002
Location: Toronto, Canada
Distribution: RH 9, Gentoo 1.4: Fluxbox!!!
Posts: 96

Original Poster
Rep: Reputation: 15
wow.

interesting.

thx for the reply guys.

i did not know that database's can be "so" in terms of standards.

so i guess none of them have a "query analyzer" like MS SQL Server?
 
Old 05-24-2004, 06:05 AM   #5
thick_guy_9
Member
 
Registered: Jan 2004
Location: Singapore
Distribution: VMS, RHEL, Slackware & FreeBSD
Posts: 99

Rep: Reputation: 15
if you can get hold of Sybase ASE 11.9.2 from www.sybase.com/ase
for Linux, then it will pretty much be the same as MS SQL server, interms of sys tables.
The GUI, sorry, you may not get it.
 
  


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
PostgreSQL: Installed 7.4 on Redhat 9.0 but can't run pgcrypto.sql. gregmcavoy Linux - Software 0 12-29-2003 12:37 PM
Will MS SQL run on a Linux box? cvonhelf Linux - Newbie 2 10-20-2003 03:01 PM
How do I run an .sql script? vous Programming 6 08-07-2003 11:11 AM
I need to run SQL digital bots Slackware 10 07-01-2002 01:31 PM
cron to run a an sql query and send Email ehsan Linux - General 2 03-14-2001 11:50 PM


All times are GMT -5. The time now is 11:27 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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration