I am also interested as a Medtech32 user. Standard sql queries seem to
work. Does the database need to reside on the web server?
Jim
Chris Tansell wrote:
Does anyone know if this is possible with a MedTech32 database?
Is it possible to migrate the data so simply?
Cheers,
Chris.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Horst Herb
Sent: Sunday, 22 October 2006 4:13 PM
To: General Practice Computing Group Talk
Subject: Re: [GPCG_TALK] SQL schema for billing
On Sunday 22 October 2006 14:44, Richard Hosking wrote:
as Pracsoft to a rails DB. If the DB schema is known this should be
possible using a Ruby script.
The db schema of pracsoft is known and quite simple.
On Linux, you can use "mdbtools" to migrate the whole prasoft database to
postgres or mysql with a single command
(On Debian / Ubuntu you can install mdbtools with "apt-get install
mdbtools", then read the man file, copy the pracsoft Access database file
onto your Linux box, and you are done in minutes.
Make sure you use the switches for "safe names" = replacing all spaces with
underscores in table and column names etc
Once you have exported the database to postgres, you can use tools like
pgadmin3 to explore the database schema (apt-get install pgadmin3 ...)
Horst
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
