Joseph Koenig <[EMAIL PROTECTED]> writes: > 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,
Probably the best thing to do is to export the data from Progress in a format that the PostgreSQL COPY command can read. See the docs for details. -Doug -- Let us cross over the river, and rest under the shade of the trees. --T. J. Jackson, 1863 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
