hi i started using openemr and have some data in mysql there in linux. i think synapse may be a bit less cumbersome so any idea how to get the data over to it? only text no scans.
I guess it depends on how much data you have ... but you should be able to use a data pump utility ( lots you can download ) to pull data out of mysql and into the Firebird tables that Synapse uses ...
BTW, since you already have a linux server (?), you can install Firebird on your linux box, copy the REMR.FDB that Synapse uses to it, do the data port there. Synapse-server is still only a windows binary so you need a windows box as well. But it could connect to the database on linux box by setting this up in ODBC.
Does anyone out there want to share what utilities may have been successful transferring MySQL to Firebird? I've found this http://www.clevercomponents.com/products/datapump/datapumpfaqs.asp Any thoughts?
I've never used a datapump preferring to write scripts by hand ... but since they're offering a 30 day money back guarantee ... The thing is, you would have to know the database schema of both Synapse and the other product quite well inorder to transfer the data across, and you have to get the primary keys right.
