Migrating Fox (dbf) to PostgreSQL

[Jean-Claude Adams]

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

[Josué Maldonado]

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.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Josué Maldonado]

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.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match