Hello. I am evaluating Toad Data Modeler to see how useful it can be to reverse engineer some Access databases to MySQL. This software appears to be very powerful and I am excited to learn more about it, but am having some issues just getting started for my particular use case. Perhaps someone here can help.
What steps are needed to convert a simple MS Access 2003 database to a MySQL 5.1 database that can be imported to MyPHPAdmin? I reverse engineered the database, then I added a database and assigned the tables to it, then I generated a DDL. I am still getting a #1049 Error Unknown Database ‘foo’.
Are there any tutorials for using TDM, rather than just showing functionality? I found a dated tutorial on YouTube that would have been very helpful if the UI had not changed so much. The flash “guides” are difficult to use because viewers cannot go backward, only forward, so we cannot consume the content in any order except how it is presented. Also, the content is about what the buttons do rather than how to use them in combination to achieve a goal. The help files are also difficult to use for this latter reason. I know that people use this software for many reasons, but a couple tutorials that take a new user through the process of reverse engineering a database of one common type to another common one (e.g., Access to MySQL :)) would be very helpful.