Perfect MS Access to MySQL Dump File Converter
Posted: Tue Oct 23, 2007 9:12 pm
After messing around for a few days tripping over bugs 'desired features?' in DBTools/MySQL, your utility has finally allowed me to get some sleep. Thanks!
A friend of mine asked me to build a web app for his site. It all seemed simple enough so i agreed. Then i find the database he uses is MySQL, no problem i think. HaHaHA.
I have spent more time messing around with the database than the time I'll spend making the app! After attempting to use DBTools to modify what he had already done, i gave up and decided that if i could write a quick function to build an .sql file from a database built in msaccess, I'd save myself some trouble. HAHAHAHAHA.
I was just digging a deeper hole for myself. With little, 'virtually none', useful feedback from MySQL or DBTools or useful information on the web, progress was slow and errors were persistent, even having a good grasp of SQL DDL. I almost got there but had unexplained problems inserting records using the dump file. Whilst searching for a tool to debug the .sql dump file i created I came across your site and bingo. First time a successful restore of the full database from the file created by your tool and then i tried it directly into MySQL, again no errors. Great!
When I have some cash I'll be donating some for curing my headache.
Good work.
The only thing I'd like to see in this tool is a reverse path so i can get what is already in MySQL into access but i think i can handle building a function for that. MSAccess might not be great but it's a dam sight better than MySQL/DBTools, even if unmodified since MS bought it from whoever.
One other thing I'd like to see if MySQL is capable of handling it, which i think it is not, would be stored query conversion too. I have read that MySQL doesn't handle stored procedures well, which is un-****ing believable and people moan about MS? That's like a bus with no driver or having a dog and having to bark yourself. If you're as good as i currently think you are, maybe you can crack this one too. I'm sure it IS possible, just that people would rather spend half their life writing queries on the code side, rather than their whole life trying to get them working in their proper place, in the database!
Anyway, thanks again. As well as donating, next time I'm in Copenhagen I'll buy you a beer or three in the Irish Rover.
A friend of mine asked me to build a web app for his site. It all seemed simple enough so i agreed. Then i find the database he uses is MySQL, no problem i think. HaHaHA.
I have spent more time messing around with the database than the time I'll spend making the app! After attempting to use DBTools to modify what he had already done, i gave up and decided that if i could write a quick function to build an .sql file from a database built in msaccess, I'd save myself some trouble. HAHAHAHAHA.
I was just digging a deeper hole for myself. With little, 'virtually none', useful feedback from MySQL or DBTools or useful information on the web, progress was slow and errors were persistent, even having a good grasp of SQL DDL. I almost got there but had unexplained problems inserting records using the dump file. Whilst searching for a tool to debug the .sql dump file i created I came across your site and bingo. First time a successful restore of the full database from the file created by your tool and then i tried it directly into MySQL, again no errors. Great!
When I have some cash I'll be donating some for curing my headache.
Good work.
The only thing I'd like to see in this tool is a reverse path so i can get what is already in MySQL into access but i think i can handle building a function for that. MSAccess might not be great but it's a dam sight better than MySQL/DBTools, even if unmodified since MS bought it from whoever.
One other thing I'd like to see if MySQL is capable of handling it, which i think it is not, would be stored query conversion too. I have read that MySQL doesn't handle stored procedures well, which is un-****ing believable and people moan about MS? That's like a bus with no driver or having a dog and having to bark yourself. If you're as good as i currently think you are, maybe you can crack this one too. I'm sure it IS possible, just that people would rather spend half their life writing queries on the code side, rather than their whole life trying to get them working in their proper place, in the database!
Anyway, thanks again. As well as donating, next time I'm in Copenhagen I'll buy you a beer or three in the Irish Rover.