Thread: Migrating Fox (dbf) to PostgreSQL

Migrating Fox (dbf) to PostgreSQL

From
jcroot@card.net.py (Jean-Claude Adams)
Date:
Hi Folks.

I need some tutorial or some expertice about the subject. Because, i'm
have a customer, need's change the actual appl, but the only issue is
a dbf database, and the GUI is the older blue screen. You know, it's
very old and huge data to migrating.

Well, the challenge for me now, it's create the structure and change
thhe interface, well, is the same menu, but other screen for the user.
i'm always like for backend the postgresql, is for this, i'm proposse
to migrating posgresql.


resume: i'm need tips, task, tutorial's, tools and some help for you,
or some manual, because i'm like change the actual backend to
posgresql.......


Thanks

Re: Migrating Fox (dbf) to PostgreSQL

From
Josué Maldonado
Date:
Hello Jean,

El 25/04/2004 8:57 PM, Jean-Claude Adams en su mensaje escribio:

> Hi Folks.
>
> I need some tutorial or some expertice about the subject. Because, i'm
> have a customer, need's change the actual appl, but the only issue is
> a dbf database, and the GUI is the older blue screen. You know, it's
> very old and huge data to migrating.
>
> Well, the challenge for me now, it's create the structure and change
> thhe interface, well, is the same menu, but other screen for the user.
> i'm always like for backend the postgresql, is for this, i'm proposse
> to migrating posgresql.
>
>
> resume: i'm need tips, task, tutorial's, tools and some help for you,
> or some manual, because i'm like change the actual backend to
> posgresql.......

Postgresql includes an utility called dbf2pg, you can use it to upload
the current Fox data to pg, be carefully to "clean" the dbf tables prior
upload, you will need to pack them and replace missing date values with
some value.



--
Sinceramente,
Josué Maldonado.
"Es mucho mas difícil juzgarse a si mismo, que juzgar a los demas. Si
consigues juzgarte rectamente, seras un verdadero sabio." --Antoine de
Saint-Exupery.