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?

[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

[richard_selby]

I moved an entire table, so encoded queries didn't enter in to it.

[cfs]

HI Solution/Ravi1 & Richard,

Can i check how did you manage to get this work?

I've recently tasked with the requirements of migrating Incidents/Problem management worknotes/activities from Production Instance to Development Instance, would like to seek helps from Gurus in this community to help out guiding me.

It seems that i've uploaded Retrieved update sets on the production environment & tried the solutioning approach of using URL to export the XML, it doesn't seems to work.

Regards,

Tristan CFS

[aaronhalverson]

Hi,

I've test this also and it works like a charm for a single table.   I have a requirement to export a number of tables, does anyone know how I could execute this from a script?

Regards,
Aaron.