I have used tools like MySQL Migration Toolkit (*) and Bullzip’s Access To MySQL utility, both do a excellent job but without relationships. We can spend a lot of hours to identifying and creating relationships until now:
I have write a VBA script to identify MS-Access relationships and create MySQL code with SQL-CREATE sentences, it will be useful after migration process using any free tool:
Option Explicit
'Put this function in new/existing MS-Access module.
Public Sub printRelations()
Dim sql, fk As String
Dim i, j As Integer
For i = 0 To CurrentDb.Relations.Count - 1
sql = "ALTER TABLE `" & CurrentDb.Relations(i).ForeignTable & _
"` ADD CONSTRAINT `" & CurrentDb.Relations(i).Name & "` FOREIGN KEY ("
fk = "("
For j = 0 To [Read more...]