Migrate Incident data from one instance to another instance

[VanamaA]

Hi Team,

I have a requirement to export incidents(700) from one instance to another instance,including emails,audit history.

I have exported all the incidents using xml,but the history of tickets was not moved.For that I thought of moving sys_audit for those incidents.

But in sys_audit table,is there any possibillity to export all the history of those 700 incidents instead of doing it one by one as below screen shot.because we dont have "is one of" operator

Any suggestion i can get will be very helpful.

[Ankur Bawiskar]

@VanamaA 

what's the business requirement to migrate?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[VanamaA]

Hi @Ankur Bawiskar 

We are planning to move all our existing data/configurations from MSP(Domain seperated)instance to dedicated instance.

We have completed everything and only the Historical data is pending in Dedicated instance.

Note: we are not following any Migration tool.

[J Siva]

HI @VanamaA 
if you are trying to move the data from production to non prod environment, then please do clonning if possile.
It'll be simple and staright forward approach

Regards,
Siva

[VanamaA]

Hi Siva

Its not moving data from prod to subprod.

We are planning to move all our existing data/configurations from MSP(Domain seperated)instance to dedicated instance.

We have completed everything and only the Historical data is pending in Dedicated instance.

Note: we are not following any Migration tool.