Hello Progress Experts:
I need help to transfer data from Source DB to Target DB using data migration programs. The name of the Source DB and Target DB will be accepted at Runtime.
The Functionality of the data migration program will basically be to extract data from Source DB and populate the new created Target DB.
I tried to connect both the DB's in my code. I am able to connect both the DB's. My problem is when I need to extract data from Source, I need to generically prefix the name of the source DB such that when I load the data into the same table in Target DB, it should allow me.
For example:
1. Moving all records from MFG/PRO customer master, "cm_mstr" from source (old version of DB) to target (OpenEdge 10.1A) using progress code.
Psuedo code would be something like;
for each source.cm_mstr where source.cm_mstr.cm_addr begins "S" :
create target.cm_mstr.
assign target.cm_mstr.cm_addr = source.cm_mstr.cm_addr.
<other fields>
end.
Since I am dynamically accepting the source and target DB names, how can I use above logic. Please help. If time is a constraint, kindly give references of examples available in other sites/URL's.
Thanks in Advance.
Ajay.
I need help to transfer data from Source DB to Target DB using data migration programs. The name of the Source DB and Target DB will be accepted at Runtime.
The Functionality of the data migration program will basically be to extract data from Source DB and populate the new created Target DB.
I tried to connect both the DB's in my code. I am able to connect both the DB's. My problem is when I need to extract data from Source, I need to generically prefix the name of the source DB such that when I load the data into the same table in Target DB, it should allow me.
For example:
1. Moving all records from MFG/PRO customer master, "cm_mstr" from source (old version of DB) to target (OpenEdge 10.1A) using progress code.
Psuedo code would be something like;
for each source.cm_mstr where source.cm_mstr.cm_addr begins "S" :
create target.cm_mstr.
assign target.cm_mstr.cm_addr = source.cm_mstr.cm_addr.
<other fields>
end.
Since I am dynamically accepting the source and target DB names, how can I use above logic. Please help. If time is a constraint, kindly give references of examples available in other sites/URL's.
Thanks in Advance.
Ajay.