Any Good Way To Do Sync DB's?

From: Joseph Koenig <joe(at)jwebmedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Any Good Way To Do Sync DB's?
Date: 2001-10-12 21:11:53
Message-ID: 3BC75C9A.8425D708@jwebmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2001-10-12 22:01:02 Re: pop3 server and Postgresql
Previous Message Doug McNaught 2001-10-12 21:02:37 Re: VACUUM, 24/7 availability and 7.2