Is it possible to load the Qxtend archive xml back to a new database.
Posted: Feb 01, 2019
I am not aware of such tool and the content may not be possible to be loaded back to QXODB. What we did in some for some customers was to delete / archive QXO transactional data via Progress batch job so that we can define different retention periods for different messages (BO/Profile), and during such operations, the data was dumped to .d files and can be loaded back to the system if needed.
Replied: Feb 14, 2019
Just keep in mind the documents are tied together so just loading part of the tables may not work right.
Maybe alternative is to copy the entire qxo db and then from that new copy purge what you don't want.
The standard purge would not do this btw. You could do multiple copies and purge all data except for each year in each one for example.