Dick Applebaum wrote: > On Wednesday, October 9, 2002, at 10:39 AM, Jochem van Dieten wrote: > >>- use a utility to move the data (available for most open source >>databases such as PostgreSQL and MySQL). > > Can you point me to a reference?
http://pgadmin.postgresql.org/pgadmin2.php?ContentID=1 http://www.google.com/search?q=mysql+access+converter&spell=1 > Is it true that you these utilities create a mirror (MySQL or > PostgreSQL) db as an intermediate to the ultimate target RDBMS? They usually just take the data and move it. Normalization etc. still has to be handled by the programmer later, but it does not require a separate database, just some separate tables to store the data temporarily. >>- make an ODBC datasource for the RDBMS you are going to use, create >>the >>tables in it and use Access linked tables to move the data over. > > > As I understand this, you are essentially mirroring the Access tables > on equivalent target RDBMS, and copying over the data. Any validation, > normalization then uses the target RDBMS linked tables as a source. > > So the target RDBMS Access linked tables are an intermediate step/copy > of the data. Yes. >>- export the data as .csv and read it into the new database >> >>The last to can also move data in the other direction. >> > > > These both involve intermediate files or databases, correct? Intermediate files and tables, not necessarily databases. > What I am looking for is a solution where I can write a CF program that: > > 1) runs on a non-win platform > 2) can read/write MS-Access dbs directly (no intermediate files or > dbs) Hadn't I read your OpenLink comment, I woud have said that these 2 already are conflicting (unless you count virtual PC simulators). But OpenLink like software is what you need. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
