Re: [GENERAL] Converting Other DBes to Postgres & JDBC

On Mon, 23 Nov 1998, Ulf Mehlig wrote:

> Dmitry Iv Popov <mitlas(at)auricvision(dot)com> wrote:
>
> > how can I connect/convert Visual FoxPro database to PostgreSQL and
> > read data from it from my Java applet (i.e. is there JDBC public
> > driver)?
>
> What do you mean by connect? Are you planning to access a PostgreSQL
> server over a network or do you just want to experiment with another
> database system?
>
> There is a JDBC driver "delivered" with the sources of PostgreSQL 6.4
> (../postgresql-v6.4/src/interfaces/jdbc/).

Don't forget I have precompiled drivers on my web site.

> There should be the possibility to transfer data from one database
> system to another via two JDBC driver connections, but I've never tried
> that (it should be possible with all that XxxMetaData stuff to write a
> general data transfer program, if there are suitable JDBC drivers,
> shouldn't it?).

In theory, it should be. The problem is that there are not many drivers
that implement the full API.

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf