Does anyone know how to connect a foxpro database to the web using Linux, Zope and Postgresql? Right now, we're using dbf2pg to convert the data 5 times a day from foxpro to postgres, but this is just a stop gap solution. The data is not updated, but the tables are 50M each and running the conversion takes more than an hour. Any suggestions? Thanks in advance, Liz
Liz Pelletier wrote:
Does anyone know how to connect a foxpro database to the web using Linux, Zope and Postgresql? Right now, we?re using dbf2pg to convert the data 5 times a day from foxpro to postgres, but this is just a stop gap solution. The data is not updated, but the tables are 50M each and running the conversion takes more than an hour. Any suggestions?
Use the postgres windows odbc driver to connect to the database. You'll find it at http://odbc.postgresql.org/ cheers, oliver
Exporting to comma-delimited or some delimited format, alternately fixed width format, and importing with the pg bulk import tool, might go faster. Nitin Borwankar Liz Pelletier wrote:
Does anyone know how to connect a foxpro database to the web using Linux, Zope and Postgresql? Right now, we're using dbf2pg to convert the data 5 times a day from foxpro to postgres, but this is just a stop gap solution. The data is not updated, but the tables are 50M each and running the conversion takes more than an hour. Any suggestions?
Thanks in advance,
Liz
participants (3)
-
Liz Pelletier -
nitin＠borwankar.com -
Oliver Bleutgen