how to create a data preserver to keep every record in the target table

[Efra Pruneda]

I need to set up data preservers to keep all the records for a given table in the target instance. Do I simply create a data preserver without a condition?

also, because I don't want any records from the source instance. I need to create an exclude table entry for the same table.

for example, I want to keep all the records in the pm_project table in the target instance. here is what I think I need to do:

1. create an exclude table entry for pm_project - this will prevent new records from the source instance

2. create a data preserver for pm_project with a blank condition - will this keep every record in the target table?

can someone give me your thoughts? I really appreciate any help you can provide.

Efra

[Saurav11 · Accepted solution]

Hello,

Please find below a HI article which explains this in detail:-

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0717012

Please mark my answer as correct based on Impact.

[Efra Pruneda]

thank you Saurav, this is exactly what I was looking for!

[Mark Roethof]

Hi there,

You are correct regarding the data preserver and exclude tables. What you are describing should be good.

Question though for yourself to think about... is there also related data that should be preserved? pm_project might have references to other data. 

Kind regards,
Mark

[Efra Pruneda]

thank you for your reply Mark, you are correct, we should create more data preservers to cascade preserving data to other tables in the target instance. pm_project will have references to other tables and these tables in turn to others.