Access --> MySQL Port

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 427,934 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,914 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Thread Tools Display Modes

Views: 7915 | Replies: 2

•

Join Date: Oct 2004

Posts: 1

Reputation: jcolome is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

jcolome

Offline

Newbie Poster

Re: MS Access vs. MySQL

Oct 15th, 2004

I have a portal site www.localmiamiguide.com that needs to be transfered to mysql. Anyone have any idea how much that would run me? :cry:

Please advise.

Jcolome

•

Originally Posted by fsn812

I have worked on large scale projects using Oracle, medium sized projects using MySQL, and some small projects using Access. All have worked great for the most part. However, I have seen problems with Access and I am not impressed overall. I'm sure Access is great for small single user environments, but I wouldn't trust it with the amount of data our DBA's and Admin's handle.

Of course, we use Oracle for our largest projects. Don't get me wrong, it's great that MySQL has transaction support (finally) and should have trigger support (probably in 5.1), but for large projects I am not convinced MySQL has the scalability yet.

For desktop or a small-medium server? MySQL or PostgreSQL all the way. MySQL has come along way since previous 3.x.x. Unless you can afford a high end scalable database program, or unless you need it, I would suggest going with MySQL and NOT Access.

•

Join Date: Nov 2004

Posts: 1

Reputation: svrusso is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

svrusso

Offline

Newbie Poster

Re: MS Access vs. MySQL

Nov 11th, 2004

•

Originally Posted by jcolome

I have a portal site www.localmiamiguide.com that needs to be transfered to mysql. Anyone have any idea how much that would run me? :cry:

Please advise.

Jcolome

I suggest you check out Rentacoder.com. This site allows you to post various contract jobs and have different coders bid on your project. You can specify the size of the job and the maximum amount of money you are willing to spend. It also acts as a middle man between the coder you choose and the person requesting the work, effectively offering protection to both parties in the case of any arbitration.

Feel free to invite me to bid on your project after you check out the site (russosv)!