• 0

MySQL vs Access


Question

Hi all,

I want an openion about using Microsoft Access or MySQL. to create and mentain a Dbase drivin website which would have large amout of enteries.

which is easier?

which is more stable?

is there visual tools for MySQL ?

Thank you for your great support in advance.

Link to comment
Share on other sites

Recommended Posts

  • 0

MSSQL all the way...

its much faster and more professional plus its "served" meaning you can access it over a network

As for visual tools , anything that allows you to connect through ODBC should work , I use visual studio.Net... You can probably use the access interface as well

MySQL is also worth looking at if you want something thats fast and served but also free

Link to comment
Share on other sites

  • 0

As far as "easy" is concerned MSSQL or MySQL take a little more setting up but still nothing difficult , and since all databases (in theory anyway) use the SQL standard the actual use of the database should be exactly the same..

Link to comment
Share on other sites

  • 0

MySQL with out a doubt. Faster than Access, more reliable than access, cheaper than access. I don't know of any advantage Access has over MySQL. Access isn't even Microsoft's best database. MsSql is, but it's not as good as MySQL or PostgreSQL.

Link to comment
Share on other sites

  • 0

MSSQL (SQL server) has allot of enterprise / business logic related features that MySQL lacks at the moment , MSSQL is also faster when dealing with large amounts of data and allot of transactions (it has the world database speed record) , of course it isnt cross platform and it costs more.

Im pretty sure MySQLFront doesnt have support for MSSQL and neither does phpmyadmin....

The main advantage of Access of MySQL is that you dont need to setup a server to run it and everything comes in a single easy package including the interface and all the design tools.

Also most of the best MySQL admin tools you end up paying for....

I wouldnt bother with oracle unless you know allot about databases (in which case this thread wouldnt exist) and you have allot of money...

Link to comment
Share on other sites

  • 0

Thank you guys for your quick response,

I see I would go for MySQL as you all advised.

but is there any specific tool, I can use visually to create my database.

or where can I get these tools :rolleyes:

Link to comment
Share on other sites

  • 0

OK well the best is EMS MySQL manager but that costs money although there is a 30 day free trial, there is also mysqlfront which has been discontinued , If you want something free try MySQL control centre , its pretty simple and fairly easy but not as pretty as something like access, also phpMyAdmin allows you to control your database via the web (just make sure you install it into a secure folder!)

Link to comment
Share on other sites

  • 0

here we go again... i can see where this is gonna lead to.... arguing which is better....listen man... shut up i don't wanna start an argument over which database is faster.... i heard and i believe that MySQL is faster thats all

Edited by zionath
Link to comment
Share on other sites

  • 0
but is there any specific tool, I can use visually to create my database.

PHPmyAdmin is a web interface that will allow you to do about anything you want - create,delete,manipulate data,add tables, drop tables, etc.. etc.. - get here: http://www.phpmyadmin.net/

Part of webmin has a pretty slick little tool for working with databases in MySQL - its a amin interface for linux boxes - so if your database on a linux box - this is great to have. Can get here: http://www.webmin.com

You could also try MySQLGUI - Bythe people who brought you MySQL ;) - http://www.mysql.com/downloads/gui-mysqlgui.html

Hope this helps - by the way my vote is for MySQL :)

Link to comment
Share on other sites

  • 0

dont bother with MySQL GUI its out dated and nasty , the best combo is EMS MySQL manager with PHP MyAdmin , The database tool within Visual Studio.Net can also be used if you add a MySQL ODBC driver...

Link to comment
Share on other sites

  • 0

Rathamon calm down, I don't think he's going to be running a big ecomm. site...

Anyways MySql is the one of the best IMO, also onsi you can just use phpmyadmin if its going to be edited thru online. If you were actually running it off your machine for example, the gui interface for MySql is fine IMO, sure its old but it works.

http://www.phpmyadmin.net/

Link to comment
Share on other sites

  • 0

Rathamon u really got problems init?... i said don't bother aruging.. wha u do?... u argue... i said wha I believe..... i didn't say anything about " i recommend mysql " and bla bla bla etc.... i just said wha i believe... move away wid alll your benchmark crap.. doesn't mean anything to me... one website has one set of benchmarks.... another has a different set bla bla and so on... i can tell ur a Microsoft fanboy :p

Link to comment
Share on other sites

  • 0
Rathamon u really got problems init?... i said don't bother aruging.. wha u do?... u argue... i said wha I believe..... i didn't say anything about " i recommend mysql " and bla bla bla etc.... i just said wha i believe... move away wid alll your benchmark crap.. doesn't mean anything to me... one website has one set of benchmarks.... another has a different set bla bla and so on... i can tell ur a Microsoft fanboy :p

dude , I have yet to find a benchmark where MySQL outperforms SQL Server for any serious function , those benchmarks were taking from the "Transaction Processing Performance Council" so if they arent definative I dont know what is , MySQL show fast benchmarks on their webpages beating various database servers but they dont even mention SQL Server hmm I wonder why...

You can't say "I believe this" and not provide a valid reason , that just makes you look stupid , Also look at who suggested MySQL first in this thread , might it have been me? I advise you to actually READ the thread and the facts before posting retarded crap

Link to comment
Share on other sites

  • 0

MySQL isn't the fastest around - not by a long shot.

SQL Server, Oracle are much much faster.

Access is not really a good choice because

a) it can't handle being hammered

b) it isn't really a client-server database

Now, with all that said, what about MSDE. Which is known as SQL Server lite. This is a much better choice. MSDE doesn't have a GUI but you can downloaded the SQL Server Trial and use the familar enterprise manager (which doesn't time-out) to manage your database.

MSDE stands for: Microsoft SQL Server 2000 Desktop Engine

This is a fully functional database which will outperform access and I think will outperform MySQL and will be a lot easier to maintain.

The cool thing about MSDE is that if you get the point where you need an enterprise database you can seemlessly swap MSDE for SQL server since they are identical in the database structure.

Here are directions setting up MSDE to use with ASP.NET (MS's free ASP.NET IDE - Looks exactly like VS.NET but only allows webdev, but it is free).

http://www.asp.net/msde/

Overview

The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a data engine built and based on core SQL Server technology. With support for single- and dual-processor desktop computers, MSDE 2000 is a reliable storage engine and query processor for desktop extensions of enterprise applications. The common technology base shared between SQL Server and MSDE 2000 enables developers to build applications that can scale seamlessly from portable computers to multiprocessor clusters.

Designed to run in the background, supporting transactional desktop applications, MSDE 2000 does not have its own user interface (UI) or tools. Users interact with MSDE 2000 through the application in which it is embedded. MSDE 2000 is packaged in a self-extracting archive for ease of distribution and embedding.

http://www.microsoft.com/sql/techinfo/deve...00/msde2000.asp

Link to comment
Share on other sites

  • 0

Well, I know MySQL (especially 4, which there aren't any really good benchmarks on ATM, as it's still in beta) is the fastest at SELECT statements. It doesn't scale well, but it's the best for smaller sites (less resource intensive and faster in smaller environments).

Link to comment
Share on other sites

  • 0

Guys, :D

Thank you for your great support. :rolleyes:

I had MySQL and PHP..

until now I am using Dreamweaver until I find an easier software

to help me creating better web interfaces for my database.

Actually it would be a big ecommerce site. :cool:

Thank you againg for all your support. :D

Link to comment
Share on other sites

  • 0

Onsi , are you sure you have the necissary knoledge and experience to run a large E-commerce site , especially considering the security and performance issues involved , if your taking credit cards over your server , you really need to know the languages / operating system & databases inside out

Link to comment
Share on other sites

  • 0

:D I believe you are right with that security issue.

I have an MCSE and MCDBA certificates. :blush:

Actually I did work with Power Builder on a SYBASE Database Engine too.

but I never used MySQL, and Itegerate it with PHP.

as I am always keen about people points of view. and I was searching

for a visual tools to help me get the work done quickly

rather than write the whole thing from a scratch.

I hope I would create the desired DBASE :blink: with the optimum security.

is there any advise I should take into considerations :cry:

Thanks.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.