To choose which DB

nikhiltechnology · #1 (**permalink**) 06-07-2005, 03:59 AM

Hello everybody,

I have some basic question about choosing a right database.
I'm new in database world and also in these days i read "Database System Concepet" by Abraham Silberschatz Henry F. Korth S. Sudarshan.
So i want to learn a database system like "MySQL" or "Oracle" or "MS SQL Server" after learning database system concepts.
But i'm in doubt and i dont know which one is better.
I want to learn a database system which support large and medium project.
Of course some frindes suggest "Oracle" but i'd rather know your suggestion too.
and which one works with "ASP.NET" perfectly?

Thank you

Reguards
Nikhil

spyrit · #2 (**permalink**) 12-20-2005, 12:52 AM

MS Sql Server is by far the best. However, if you want to use it on the net, there are not many hosting proividers who "provide: it..so you should choose my sql. But as i sayd ,i've used several of them and MS Sql Server rulez

dynaweb · #3 (**permalink**) 09-12-2006, 03:09 PM

MSSQL is the best, but MySQL is the best for the $$ and more user friendly IMO. You will only notice the difference in HUGE DBs too so in reality about the same.

netprophet · #4 (**permalink**) 10-09-2006, 12:27 PM

can u give me some url where i learn my sql.

dynaweb · #5 (**permalink**) 10-09-2006, 12:39 PM

h t t p :// w w w . sqlcourse.com/
h t t p :// w w w . w3schools.com/sql/default.asp
h t t p :// databases.about.com/od/sql/

netprophet · #6 (**permalink**) 10-10-2006, 06:36 AM

Quote:

Originally Posted by dynaweb

h t t p :// w w w . sqlcourse.com/
h t t p :// w w w . w3schools.com/sql/default.asp
h t t p :// databases.about.com/od/sql/

thanx 4 reply

jvmills · #7 (**permalink**) 03-22-2007, 10:17 AM

MSSQL is probably the best, but it isn't cheap!!

MySQL is not far off the quality of MSSQL, but its available FOC, so I would plump for that. Although to be fair MS have released a SQL server Express edition which is also free but the db size is limited to 4GB, and certain functionality is omitted. Not bad for free though!

jitender · #8 (**permalink**) 04-01-2007, 05:02 PM

i think mssql is good database
and 4GB is good for small sites.

niceguy_81333 · #9 (**permalink**) 05-11-2007, 01:05 PM

i feel, mysql is the best.in the process of developing a project. If u r using LAMP combination u should no doubt use mysql

jvmills · #10 (**permalink**) 05-11-2007, 09:29 PM

Yep, if you are starting something new then MYSQL is great, its just if you have got used to DTS, replication and full text search, which are features of MS SQL... thats when you have problems.

To choose which DB

Databases