Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Importing Data from Paradox or DB2/400

0 views
Skip to first unread message

Linda Lannen

unread,
Jul 8, 1996, 3:00:00 AM7/8/96
to

I'm looking for recommendations for a project involving a one-time import of
data. Our client has a database which is in both DB2/400 and Paradox.
We need to port the data into a Notes database, and can choose which source
(DB2 or Paradox) we want to use.

I would appreciate and recommendations of tools and methods for any
similar projects done. Thanks for your time.

P.T.Lim

unread,
Jul 9, 1996, 3:00:00 AM7/9/96
to

Hi Linda,

If this is a one time job, you could use the Notes Data Access Object which utilized
ODBC. This is fairly simple if you know Lotus Script and SQL. If you anticipate a lot of
migration in the future, you might want to consider purchasing a tool like Sentinnel(by
Mayflower - uses ODBC) or ZMerge (for ASCII import only).

Hope this help.

Pee T. Lim

z...@panix.com

unread,
Jul 16, 1996, 3:00:00 AM7/16/96
to

lan...@leopard.com (Linda Lannen) wrote:

>
>I'm looking for recommendations for a project involving a one-time import of
>data. Our client has a database which is in both DB2/400 and Paradox.
>We need to port the data into a Notes database, and can choose which source
>(DB2 or Paradox) we want to use.
>
>I would appreciate and recommendations of tools and methods for any
>similar projects done. Thanks for your time.

You can export the data as CSV and import it in to Notes using COL
files.

0 new messages