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
