-
MySQL data load
-
Have a new project involving ERP system on MySQL database. Designing DW and Olap structures for decision making process. Ran into couple of problems initially in loading.
First thing was driver, didnt have a really easy connection to the database. Downloaded one free version of it (well, gnu licensing), latest .net edition. It integrated with VS and everything looked fine for 5 secs, or up untill the moment i tried to create connection to the source. Invalid registration error. Argh, no good.
I went for the older version and this time i managed to connect and transfer data from the source. Great. Or, not so great when i noticed it completely ignores collation, unicode or character set i edit. I need correct charset since there are some specifics and couldnt move the thingy from latin1 to latin2 charset (MySQL property). Oh well.
Finally, I found a really nice driver for this, it isnt free, but the single user license is 99$ and its abosutely worth every penny at this project. Smooth transfer and collation correct without any tweaiing from my part. Finally, i coul get the ball running.
If any1 is interested in driver i found, email me and ill get you the link for it. It does have a trial version.