CLONE - Difference between excluding table and data preserver

[dharanikumar]

Hi,

What is the difference between exclude tables and data preserve in clone?

What happens if we add the system critical tables like sys_db_object,sys_dictionary,sys_user_has_role in the exclusion list.Excluding these tables results in an empty table on the target instance? So, how to handle this?

[Mark Roethof]

Hi there,

Exclude table, the whole table will be ignored and not cloned to the destination instance.

Data preserve, you can make a selection (through condition builder) to preserve some records on your destination instance.

Excluding tables like sys_db_object, sys_dictionary... NO NO NO!!!
Excluding sys_user_has_role... so nobody can log in anymore 🙂 Not a way to go.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn
Community article list

[Mark Roethof]

Also see these docs pages:

https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/managing-data/tas...

https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/managing-data/con...

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn
Community article list

[Anurag Tripathi]

Hi ,

Simply Put:

Exclude Tables: - No data for this table will be cloned from source to target. Existing data will be gone though.

Data Preserve: You can choose to save(some data ,based on condition) the data from being wiped out form target instance.

If you exclude critical tables, i don't think your instance will function normally. These features are more for the transitional data and not core blocks for the platform.

Hope this helps.

-Anurag

[Anurag Tripathi]

Is this question answered or you are looking for more details?