If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ANSI SQL > Should i go for MS SQL server or MySQL or PostgreSQL (was "SQL newbie")

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-14-06, 02:44
sreenadh sreenadh is offline
Registered User
 
Join Date: Feb 2006
Posts: 1
Should i go for MS SQL server or MySQL or PostgreSQL (was "SQL newbie")

I am using WIN XP and i am starting to learn SQL. Could someone please tell me what is that best to run my SQL commands.
Should i go for MS SQL server or MySQL or PostgreSQL.
Oracle is too big to run on my PC & difficult to get. So, pls tell something i can download for free.
Reply With Quote
  #2 (permalink)  
Old 02-14-06, 02:56
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
Both MySQL and PostreSQL are free. The Developer Edition of Microsoft SQL is $50 US, but the Express Edition is free. You'll have to sort out what you want to use based on your needs, but I'd be inclined to recommend the Developer Edition for many reasons if you are looking to learn a marketable skill.

-PatP
Reply With Quote
  #3 (permalink)  
Old 02-14-06, 11:33
LKBrwn_DBA LKBrwn_DBA is offline
Registered User
 
Join Date: Jun 2003
Location: West Palm Beach, FL
Posts: 2,455
Cool


Also Oracle Express is free.
[/B]
__________________
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
Reply With Quote
  #4 (permalink)  
Old 02-14-06, 12:10
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,246
last itme I heard you can also get a DB2 version for free. I think virtually all of the SQL server products have a free offering - must be getting scared that new users may get hooked on using MySQL or POSTGRES!
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #5 (permalink)  
Old 02-14-06, 17:40
John Grubb John Grubb is offline
Registered User
 
Join Date: Jan 2006
Posts: 27
Unfortunately, all the db's mentioned have "enhancements" to the SQL specification that can very quickly make your SQL code db specific. There are 2 things to consider:

1) Is this for a specific Project? Are you planning on building an particular application?

2) Is this about the Database, and DBA routines, and Serverside SQL programming, or about getting data out of the DB.

If it for a specific project, you need to consider the specs and eventual architecture.

If it's about managing or programming a database, each db has SIGNIFICANT differences. Pick one or more and become proficient.

If it's about gettting data in/out of a db, choose an access method (odbc/jdbc/.Net/oledb/DBI/etc.) to interface with, and choose any one you feel comfortable with, even MS Access. The more generic the access method, the less the backend DB matters.

Jay Grubb
Technical Consultant
OpenLink Software
Web: http://www.openlinksw.com:
Product Weblogs:
Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
UDA: http://www.openlinksw.com/weblogs/uda
Universal Data Access & Virtual Database Technology Providers
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On