Moving activity history data between instances

[yeskaytee]

I,am moving one entire application from one instance(Dev) to another(Test). I was sucessful moving all other data but have issue when moving activity history data from sys_audit table. So, when i import data from sys_audit table not the entire history is gets imported. I need the activity log to imported as is with no data left behind. How do i achieve this?

[solutioningnow]

Greetings,

There are two options available:

Option 1: Clone the instance with full data

Option 2: I have done similar configuration for Exporting table data with history and attachment to xml and importing the same to other instance.

To achieve this, I have modified one of the solution of export data from multiple tables and updated the script include accordingly.

I'm attaching update set of the same for your reference.

Once you install update set, you can export data using export_table_data.do?filename=Backup&submit=Submit&tablesCSV=incident

Please mark answer as correct/helpful, if it was really helpful 🙂

Regards,

Solutioner

Enhance Knowledge NOW@ www.solutioningnow.com

http://www.solutioningnow.com/

[ravi1_tandon]

Hello Solution,

I test and it works like charm, however tehe encoded query does not work properly. When I am retrieving the update set, they are not loaded.

Can you give me an example for the encoded query? I think I will only be required to pass it in incident

./export_table_data.do?filename=DevTest&tablesCSV=incident?number=INC0025962%2Csys_journal_field%7Cname%3Dtask%5Eelement%3Dcomments

[ravi1_tandon]

I have also tried

./export_table_data.do?filename=DevDatabackup&tablesCSV=incident|number=INC0085995%2Csys_journal_field%7Cname%3Dtask%5Eelement%3Dcomments

and it takes 15 minutes to download it, however if I directly export it is quick and the file size is less which is forcing me to think that encoded query is not working.

Regards

Ravi Tandon

[richard_selby]

I've just tried Solutioner Now's update set and can vouch for it. It's a great way of moving a table, it's work notes, and it's update history from one instance to another. One note of caution - you will   need to make sure the fields and choice list entries match between instances, should your source have some extra fields / choice entries the target doesn't.

Thanks very much, Solutioner Now. A very helpful contribution to the community.