Regarding changing the SQL to fit the new DB, I have a question:
In Access you designate date values in SQL commands by surrounding them with '#'. How do you designate dates in MySQL? I assume it is different since I am getting "...error in SQL Syntax..." errors, but I cannot find how to do this correctly.
Please help! Thanks in advance.
EDIT: Nevermind - I figured it out. Just like text... with a single quote. Thanks anyway!
So if I want to migrate from MS Access to mySQL, then this is fine. But I take it therefore that I can migrate from MS Access to MS SQL, and that MS SQL is not only a server technology, but a database programming language?
you can migrate you Access database to MySQL using a suitable tool such as dbTools (www.dbtools.com.br) which will do most of the work. However its a labour saving device, it can't do everything for you. It will create the columns, indexes, and depending on the version of MySQL you are using the relationships.
It doens't however do the "whole" job, you will still need to do some work on the table & index design to get the best out of MySQL. Some of the datatypes don't match up identically, and some indexes supported in MySQL are not supported, or not supported particularly well, in Access (full text indexes come to mind).
There are differences between Access SQL & ISO SQL (and ISO SQL and MySQL SQL but these are much less then Access). I think the main ones are to do with dates and wild card expressions, use of double quotes " or single quotes around string literals etc.
I have downloaded a demo of Access to MS SQL 2.1 (Intelligent Converters).
I have mysql, a C (C:/mysql).
When I run MS SQL 2.1 convert, the program asks for a 'MS SQL Server'. Where can i find this.
It also asks for a login name and password.....?
winmysqladmin & MySqlManager are included in the C:/mysql folder.
You are trying to convert from Access to Microsoft SQL or MySQL? They are two very different database packages...
If you are trying to convert to MySQL, I recommend DBManager Professional (Freeware version). It does a pretty good job, but I am by no means an expert. I had to correct a few things, and there are some pitfalls to keep in mind if you are linking the tables back to Access, but all-in-all I am pleased with the software - especially since it is free. (http://www.dbtools.com.br/EN/index.php - Click the 'Downloads' link and fill out the form to get the installation file.)
If you are trying to convert to Microsoft SQL, I think there are some built-in tools in Access and MS SQL that will do this for you. Research it further, and I am sure you will find the information you seek.
I hope this helps!
EDIT: I just realized this information was already listed above... I guess I should read all the most recent posts before recommending something!