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

Migrate Clipper dbf to DB2

0 views
Skip to first unread message

N.V.Dev

unread,
Mar 23, 2003, 5:48:42 AM3/23/03
to
HI,

I am told to find out a way to convert/migrate the whole clipper dbf
structure and data to DB2 UDB. Will anyone let me know on howto and is
there any tool to automate this procedure.

Thanks in advance,
Dev

ABW

unread,
Mar 23, 2003, 11:39:07 AM3/23/03
to
Hi Dev,

Probably the easiest way to accomplish this would be to use a program that
can read dbf files and write to db2 files (via odbc, I presume).

The two packages I can think of for this are Access and Visual Foxpro (I'd
lean for Visual Foxpro as it's not a toy database).

If the tables are small enough (which I doubt), you could probably get away
with Excel, but am not sure.

Good luck!


"N.V.Dev" <de...@yahoo.com> wrote in message
news:da85daf0.03032...@posting.google.com...

Dmitry

unread,
Mar 24, 2003, 6:01:40 AM3/24/03
to
Hi,

Have a look at SQLWays (www.ispirer.com/products). It converts DBF files to
ASCII text files, generates DDL scripts for IBM DB2 and generates DB2
IMPORT/LOAD commands for importing data.

Best regards, Dmitry

"N.V.Dev" <de...@yahoo.com> wrote in message
news:da85daf0.03032...@posting.google.com...

0 new messages