Forum Moderators: coopster
Do anyone have anymore tut's / sites / tips you could give me to help me out. I have done moderate work with mysql. But i heard access is a far bit different to access and change with php
thanks
From Access to MySql
any directions available? [webmasterworld.com]
It should be fairly simple..good luck!
Michael
Simply go to Administrative Tools, then in Data Source. You'll want to set it up on the System tab for it to work properly (If I remember correctly).
mavherick
How close is SQL to Mysql? I couldnt find too much about it on google. they said they might put it on sql now instead of access
From what I know the major differences between MS SQL and MySQL are that MySQL doesn't have triggers, stored procedures, and views. But you don't really need them if you're going to use php and know SQL. You can just store your SQL statements in a php function.
My advice, use MySQL from the beginning. And don't forget about PHPMyAdmin, that'll be a big help.
BH
You may also want to use MySQL as the only DB and make Access work with it through MySQL ODBC drivers. In this case be sure to have primary key and timestamp columns in every table or Access won't update records.
Why would they want to use MS SQL when they can have MySQL for free?
MS SQL Server is a real RDBMS, while MySQL is still on its way to become one.
MySQL lacks several features:
- triggers
- stored procedures
- views
- subselects
- foreign keys
- full outer joins
- constraints
It's like comparing a small pick-up to a heavy truck. This also means noone would use the truck, if the pick-up is sufficient.
I do a lot of work with MySQL and I'm really a fan of it; I also have done several web projects with MS Access and MS SQL Server. One of the Access projects was switched to MS SQL Server, which was very easy. It would have been much more work to transfer the project to MySQL.
My advice for you is simple: Use the DB that best suits your needs.
If ODBC is a possible way for you to go, stay with Access and use the PHP ODBC functions.
If the ODBC solution isn't stable enough, tell them to migrate to MySQL (or PostgreSQL, if the before mentioned lacking features are a problem) and the directly access MySQL.
Entering database with a lots of data for the first time is easier using MS. Access, because it can be done locally, and then upload it to webserver, compared with MySQL where we have to click screen-by-screen accross the Internet.
Lots of my client data are based on Microsoft (like Excel, Access), but the low-cost solutions for Web-based application are "mySQL".
The big problem is: migrating the Microsoft things to mySQL based db smoothly... any idea, please raise.
josh
