Access DB to MYSQL conversion

curious about date issues

[lty83]

I'm considering converting my access db to mysql, now the only issue i'm scared of is my ASP code that compares date values and inserts them as well. I know that access date syntax and mysql date syntax are different and i would like to be able to migrate with little if no code change.

Are there any tools or a certain way i can setup my mysql db to accomplish this?

Thanks!

[ergophobe]

I don't know about date issues, but the conversion script that I use has some minor issues. In general, though, it does a great job. Why not just do a test conversion and then see how it goes?

There is a free script at

www.cynergi.net/prod/exportsql/

I have edited their instructions to add a couple of items that used to trip me up. The main one being

* In the Visual Basic window, go to Tools, References, add "Microsoft DAO 3.6 object library". This library needs to have a higher precedence than "Microsoft ActiveX Data Objects 2.1 Library".

According to the documentation:

* Excellent respect for name conversion, namespace verification, type matching, etc.
* Detects default values "=Now()", "=Date()" and "=Time()" to create types like "TIMESTAMP"

So it might just do it all for you. Definitely worth testing.

Tom

[lty83]

thanks!

checked out that website but i believe the content is no longer available, also went to main page but it seems to be a different language, do you happen to still have the script you could send to me?

Thanks!

[ergophobe]

Sorry, they changed the url

www.cynergi.net/exportsql/

[edited by: DaveAtIFG at 10:08 pm (utc) on Jan. 27, 2004]
[edit reason] DeLinked [/edit]

[lty83]

thanks again much appreciated

[ergophobe]

Sure, if you have any problems, let me know.

Tom