How to export data from and import into progress DB?

[JosTrafa]

(Linux, Progress database version 9.1C)

Can anyone please help me?

We would like to interface data (sales orders) from a progress database into another progress database, with exactly the same tables. We don't know how to do this though... we think that we should export the data from database1 to a csv file and then import the csv file into database2.

Does anyone know how to export data to a csv file and how to import a csv file into a progress database?

If we know the required script that would help us very much!!!

 

[joey.jeremiah]

We've developed a real-time replication engine from Progress DB to other datatbase types.

Private message me if you'd like to hear more.

Cheers

 

[TomBascom]

Exporting data is easy:

for each customer no-lock:
  export delimiter "," customer.
end.

The 'delimiter ","' part is optional -- by default EXPORT is space-delimited.

Importing data is a bit trickier:

repeat:

  create customer.
  import delimiter "," customer.

end.

Of course there are all sorts of subtleties and details that I didn't show but that ought to be enough to get you started

 

[JosTrafa]

Thanks for the quick response . This helps me a lot,