Which database should I use for website amongst Oracle, MS-SQLServer and MySQL, MS-Access?

Question

Which database should I use for website amongst Oracle, MS-SQLServer and MySQL, MS-Access?

Answer 1

I think it just boils down to whatever your preference is. I certainly wouldn't consider Access. I have primarily been using MySQL for the past 8 years with companies of all sizes (some whose database was over 200 gigabytes) and I think it's fabulous. Not to mention easy to install, configure, and administer. I've worked with Oracle some but always heard it was a beast to set up. Also, MySQL is free but if you want they offer Enterprise services for $595 - $4995 /server/year, or an unlimited site license for $40k/yr



https://shop.mysql.com/enterprise/

Answer 2

PostgreSQL is also a good Open Source (Free) option:



http://www.postgresql.org/



There is a never ending dispute over MySQL vs. PostgreSQL



We use it successfully for commercial systems. We have had no problems at all, and run systems of up to 200 concurrent users

Answer 3

You should be able to export the data to a comma delimited file. There is a module for oscommerce that can then import the data into a mysql database. You really DONT want to use access as an online database it is simply not fast enough for that type of use. Check the OS commercer forums, there is information on importing data.

Answer 4

MySQL is free but I'm not sure if it is as scalable as Oracle or MSSQL Server 2005.

Orcale is well known to be scalable. MSSQL is cheaper than Oracle and offers many features in Oracle.

MS-Access is a jet engine and not a Relational Database Management System. It does not support large databases.



Thank You.

Answer 5

Thats depends on the money you got fro DB, the amont of people that gona see the site and etc.



At the first use MYSQL its very nice and clean :)

Answer 6

Yes, MySQL is free. You can use it. But if you are developing a commercial website, you should consider using Oracle. Anyways your client is going to buy the database for you. :)



Still, you can use MySQL. It is also a good option.

Answer 7

PostgreSQL and mySQL are both free, but keep in mind that you do indeed get what you pay for.



If all you want to do is build tables, fill them with rows and fetch them back, either of these two is your best bet.



If youi plan to write stored procedures, functions, and triggers, both PostgreSQL and mySQL are POOR choices beccause their programming functionality is either brand new (bugs) or non-existent.



If your database server is a Windows box, I would STRONGLY suggest SQL Server



Of all of the DB packages, I prefer Oracle as do many people. It is moderately difficult to install on a Linux/Unix machine, but it has the BEST programming functionality with PL/SQL. It's performance is top notch.



MS Access is not meant for large, complex applications and should not even be considered