epicorsupport
New Member
Hi,
Running vintage 9.1D. Requesting help on the best approach to achieve the following:
- Periodic copy of Live database to MSTR database. Renaming the Tables with a prefix MSTR_xxxx
- Followed by a later 2nd copy of the same Live database merged into the above MSTR database without a Table rename.
The purpose of the above is to then run a procedure to compare the records in each Table , MSTR_xxxx with xxxx in order to find records that have changed.
Upon finding a record that has changed, assign UD Date field to todays date.
- Run Select Query to extract the changed records selecting by the UD Date field. The result is exported to a CSV file,
which are used in another process to apply updated records from Progress to a SQL Database.
- After above Select / Export, the current xxxx Tables are copied to the MSTR_xxxx Tables , and a fresh copy from the LIVE database to xxxx Tables is performed.
The above process most likely ran nightly, resulting in a CSV file of records that have been modified in the Live database by date. Date modified identified by the UD Date field.
Please comment on the best commands to use to achieve the individual tasks. Copy vs Backup / Restore.
I had planned on using Buffer-Compare while cycling through comparing records from MSTR_xxxx and xxxx table.
As I am a newbie to Progress Database commands and syntax, any actual scripts / command example is greatly appreciated.
Due to the Application running against LIVE using .r write triggers., the use of triggers is unavailable.
Thank You...
Running vintage 9.1D. Requesting help on the best approach to achieve the following:
- Periodic copy of Live database to MSTR database. Renaming the Tables with a prefix MSTR_xxxx
- Followed by a later 2nd copy of the same Live database merged into the above MSTR database without a Table rename.
The purpose of the above is to then run a procedure to compare the records in each Table , MSTR_xxxx with xxxx in order to find records that have changed.
Upon finding a record that has changed, assign UD Date field to todays date.
- Run Select Query to extract the changed records selecting by the UD Date field. The result is exported to a CSV file,
which are used in another process to apply updated records from Progress to a SQL Database.
- After above Select / Export, the current xxxx Tables are copied to the MSTR_xxxx Tables , and a fresh copy from the LIVE database to xxxx Tables is performed.
The above process most likely ran nightly, resulting in a CSV file of records that have been modified in the Live database by date. Date modified identified by the UD Date field.
Please comment on the best commands to use to achieve the individual tasks. Copy vs Backup / Restore.
I had planned on using Buffer-Compare while cycling through comparing records from MSTR_xxxx and xxxx table.
As I am a newbie to Progress Database commands and syntax, any actual scripts / command example is greatly appreciated.
Due to the Application running against LIVE using .r write triggers., the use of triggers is unavailable.
Thank You...