Thread: Which is better MS Access, My SQL or Oracle?

Hi All,

Which database you all prefer for making your application?
MS Access, My SQL or Oracle?
Please give me reason also - why you chosen the particular?
Your help will be highly appreciated..

Regards,

Depends on your application size and future scalablity. I think you are talking about web application...

and it depends on the script asp.net or php.

if it is a very small application you could use ms access with asp.net or php.

if you are planning for a large volume project and future scalability then opt for

ms sql and asp.net

or

mysql and php.

Oracle is for extremely large applications

I'd agree with the previous poster if talking about Web apps. For desktop apps, My SQL and Oracle are overkill. I would give Access a miss and go with something that's easily deployable like VistaDB.

Thanks for your answers Guys!

I was asking for both applications - Web and windows.
If I want to develop an e-commerce web application then which would be better?
And if I want to develop a MIS then which one would be better?

Your answers will give me an idea of how to choose database depending on apps..

Oh! I suppose SEO_Guy, you too have the same question..? You can have a new thread for this instead..

Oracle is gud for large applications. My SQL is used with PHP and it is easy to use and it is open source database.

better database depends on your applications and your thing but i suggestion you that
oracle is best acc to ms-access and my sql because oracle has better security and manage your application and many reason

Depends what you're planning on making e.g for php scripts on a website, MySQL is the best. For ASP.net driven apps MSSQL or access is the best.

I'd stay away from MSSQL. I've ran databases long ago with MSSQL and we've been exploited many times. I find MYSQL more reliable and safe.

Ms Access is the best for junior person and it is using to creates small database but SQL is a creator of large database in best for experts in database.

I use oralcle as my application is too large,it is a secured database language.

You can use MySql , it is very easy to use.

I think it's Oracle database. Oracle database is a large version of SQL.

if it's small sized application, better use MS Access.. but if it's big, then opt for MySql..

Originally Posted by IntraSpek

Hi All,

Which database you all prefer for making your application?
MS Access, My SQL or Oracle?
Please give me reason also - why you chosen the particular?
Your help will be highly appreciated..

Regards,

Hi.. very intelligent question.
According to me, you should use access database in small projects or websites.
If you are going for websites then MySQL is suitable and Oracle is preferred for very high databases..
Generally, you should use MySQL database for web applications.