chapman_m wrote on Friday, December 02, 2005:
Hi,
How difficult would it be to import a Megawest database into a MySql database? Has anyone done this?
Thanks,
Mike C.
andres_paglayan wrote on Friday, December 02, 2005:
please post more information,
what kind of database engine are they using?
is there an odbc driver to that engine?
chapman_m wrote on Friday, December 02, 2005:
The doctor of the clinic tells me that he can get someone to do a database dump for him. As for the engine, I am not sure about this. I’ll have to find out. I am wondering if they could dump the database into a csv format, and from there pull it into the mysql database.
If this could be done, how should the OpenEMR database be setup to handle the import?
Mike C.
sunsetsystems wrote on Friday, December 02, 2005:
There’s not a short answer to this. You have to study what you’ve got and decide how much of it you want to convert, then write code to do it.
I did a conversion from Medical Manager early this hear, and it came to about 1500 lines of Perl code. That included patients, dependents, insurance, employers, providers, appointments, billing and payment history, and wrote to the SQL-Ledger database as well as OpenEMR. The hardest part of it was figuring out the undocumented Medical Manager data formats.
– Rod
www.sunsetsystems.com