MS-database To MySQL Id like to batch them

[ruben1405241511 0]

Hi,maybe one of you already came across this, so I ask. I'll continue searching on.I've got two vocable trainers, one is Windows-native, the other one is on the web.While I can't control the output of the Windows-thing (so I can't export them to a *csv or something), I can write an import script. But since I'm not that great with Regular Expressions and don't know anything about *.mdb (that is MS SQL, isn't it?) files, I would need some finished thing to make out the field information and put it in arrays or something more readable. It wouldn't be that good if it was an OS-application, I'd like to implement in my website.Thanks a lot,Ruben

Edited March 10, 2006 by ruben (see edit history)

[romyo 0]

Well, I think that there are two software that can help you out with that kind of operation, have you tried Navicat mysql and access2mysql?

[dhanesh1405241511 0]

Dont know much in this matter .. but would suggest to look into ASP .NET scripting.RegardsDhanesh.

[Houdini 0]

You might want to try this link right HERE MSSQL2MYSQL

[CaptainRon 0]

Well incase you want to implement on your website, i think that's quite straight with PHP provided that the structure of both MS Access and MySQL databases are same (or equivalent).In any case all you need to do is make two simultaneous connections, run retrieval SQL on one and insertion SQL on the other.

[vhortex 1]

Well incase you want to implement on your website, i think that's quite straight with PHP provided that the structure of both MS Access and MySQL databases are same (or equivalent).
In any case all you need to do is make two simultaneous connections, run retrieval SQL on one and insertion SQL on the other.

one of the great approach for my part is to setup a local IIS server on the windows machine and use scripts that read and write to that file [mdb]. just make sure that the mdb file is accesable by IIS trough location alias or whatever windows call that where you map your folder into IIS logical folder structure. this is easy to do once you have IIS configuration running in your pc.

now the purpose of this setup is to use the local IIS to update the online version of the database where you can export the data in any format you want. you only need to have writes to the online database scripted in you local IIS server. for optimal use, just connect to the local mdb file using the local IIS server setup at your machine then export this via your script. no external server needed.

in case that you want it to stay online.. Houdini's link to add that API to your server online and it can convert your mdb to mySQL format.

/peace

[iGuest 3]

As per the migration purpose you can try this Data Migration Tool-reply by J vincent