|brian on Oct 5, 2009 at 2:19:43 AM (# 1)|
There are quite a few similarities but far more differences.
Both are Relational databases. Oracle uses PLSQL and SQL Server uses Trans-Act SQL. Basic queries are identical but when you get into stored procedures they are very different. When accessing data from oracle, usually numbers need special treatment as something that you'd expect to be an integer usually wants to be a float from oracle databases.
It really all depends on what other technologies you are using though and your preference.
Regarding the various technologies, using .NET you would most likely lean towards SQL Server. For Oracle, you'd most likely use the JSP engine it comes with. I've found, in the past anyway, that Connectivity to Oracle from MS based operating systems can be incredibly sluggish. Mostly you can use either of the 2 databases. My preference would be SQL Server however because of familiarity.
Also, am not sure if there is a free production version of Oracle but you can use SQL Server Express for databases less than 2GB in size (might be more with the new Express 2008 server) and performance is reduced when you have more than perhaps a dozen connections to the server.
In the end, it all depends on what you are targetting and who you are targetting. Oracle is good for unix/solaris based systems, MySQL for Linux and SQL Server for Windows but you can get Oracle and MySQL for all 3 which can make it a bit more portable.
That's my 2p worth, hope it helps.
murugami on Oct 20, 2009 at 10:30:08 PM (# 2)
This message has been edited.
does mySQL and SQL serve the same function
brian on Oct 21, 2009 at 1:00:05 AM (# 3)
mySQL and SQL are different/same.
SQL is the Structured Query Language. SQL Server is by Microsoft. mySQL is free under GPL or something similar with a license for commercial use as well.
mySQL is or can be a little peculiar depending on how you structure your queries. Having said that I've not used it in at least 3 years.