Moving work notes and comments between two instances

[Shibu2]

Hello All,

I'm trying to migrate work notes and comments (journal fields) between two servicenow instances. The tables I'm checking for the data are sys_journal_field and sys_audit. Sometimes, the specific audit records aren't available as the sys_audit table gets cleaned up quite often. Should I fabricate sys_audit records for this if it is missing? What are the required tables I need to migrate for moving the comments and work notes (activity log) of a record? do I need sys_history_set and sys_history_line as well? these tables get populated dynamically for a record only if the record is open on UI? is there a way to simulate this through script? Another thing I noticed was that, after importing the respective table records for a work note, the incident needs to be updated or saved for the work notes o show up. let me know in case there is a procedure to this is. Would be of great help. Thanks in advance.

Thanks,

Shibu

[Stewe Lundin]

Hi!

Use Soap or REST API's 

REST API

[Shibu2]

Thanks Stewe. I would like to know which tables should would be useful for replicating records with the journal entires in a different instance.

1)sys_journal_field

2)sys_audit (sometimes the sys_audit records aren't available. Should I fabricate it in that case for each sys_journal_field. Let me know. Thanks.)

3)sys_history_set (Is this relevant?)

4)sys_history_line (Is this relevant?)

Thanks,

Shibu

[Stewe Lundin]

It depends on the requirements and how granular the data has to be. 


And I'm not that familiar with how this works, so I can only guesstimate. 

Sorry for the late replay 

/Stewe