Any Good Way To Do Sync DB's? - Mailing list pgsql-general

From Joseph Koenig
Subject Any Good Way To Do Sync DB's?
Date
Msg-id 3BC75C9A.8425D708@jwebmedia.com
Whole thread Raw
Responses Re: Any Good Way To Do Sync DB's?  (Gordan Bobic <gordan@bobich.net>)
List pgsql-general
I have a project where a client has products stored in a large Progress
DB on an NT server. The web server is a FreeBSD box though, and the
client wants to try to avoid the $5,500 license for the Unlimited
Connections via OpenLink software and would like to take advantage of
the 'free' non-expiring 2 connection (concurrent) license. This wouldn't
be a huge problem, but the DB can easily reach 1 million records. Is
there any good way to pull this data out of Progess and get it into
Postgres? This is way too large of a db to do a "SELECT * FROM table"
and do an insert for each row. Any brilliant ideas? Thanks,

Joe

pgsql-general by date:

Previous
From: Palle Girgensohn
Date:
Subject: Re: Unixtime from timedate?
Next
From: Palle Girgensohn
Date:
Subject: Re: pop3 server and Postgresql