There actually is an incredibly easy way to migrate from Access to mySQL database. And I HIGHLY recommend it. It just did it myself to two WebWiz forums that I had have running for years. The speed increase alone is well worth it. Especially if your forum is open to the public where search bots are indexing the site and the forum has been around for awhile. 10 viewers on an Access database make it crawl. In fact, Borg should just ditch Access and force everyone to at least MS-SQL 2005 Express.
Follow his directions. It works great.
The key thing here is that the conversion utilities are now built into version 9. So don't worry about not finding the database upgrade utilities. This was what took the longest. It wasn't clear that the upgrade tools were included in version 9, so I wasted 3 hours looking for them online. Upgrade the access database to version 9 and then follow the conversion process.
I've sucessfully converted a version 7 and version 8 access to version 9 mysql.
So far my only problem is the version 8 to 9 one, the search function does not appear to work. But I am not sure if that is related yet.
Topic Options
Post Options
Thanks(0)
