Upgrade from MS Access to MySQL

Hi Amateur, I was pretty  sure this had been posted step by step in the forum somewhere (could be wrong)

Hi mikey,
I guess this isn't posted at all, there much examples for MSsql and not for MYsql.

Amateur there are some programs on the internet, only thing is that you have to buy most of them... I was trying this even but the most does only just 5 rules... So i started whit a clean forum and copy the values of it though a .asp script that read out the .mdb. Im sorry but i lost that file sometime ago (i was thinking of not needed anymore). Good luck whit build your own script or try some programs


Edited by -koen- - 31 December 2006 at 8:48am

Saying that tho, i'm sure it would be far simpler to go from MSSQL to MySQL

Mikey wrote: Saying that tho, i'm sure it would be far simpler to go from MSSQL to MySQL

You would've thought so, I did too. However it's not actually that simple. I've just installed MySQL 4.1 to learn it as a) I want to check my add-on code works in all databases and b) it'll save me £100 a year on server costs if I use MySQL vs MSSQL.

My first effort revolved round using DTS to convert straight into MySQL. Four tables failed - tblAuthor, tblTopic, tblThread and tblForum. Nothing importnat there then... I then exported the failed tables from MSSQL to text tiles and used the MySQL console to LOAD FILE them in. This seemed to work, but even then I found errors. Not all the dates came in and the boolean True values were set to 1, but WWF uses the old MySQL 3.x value of -1 for boolean True rather than the new v4.1 onwards standard. The latter is an easy fix in the database config file.

Currently it sort of works, but when displaying a Topic, a lot of the author details are missing and the message itself doesn't show so there is still something I haven't cracked yet. The info is in the MySQL tables, looks absolutely fine, but won't show properly. Hmmmmmm.