How to register Exclude Tables and tables that should be registered

[d-aizawa]

Hi.

I'm creating a System Clone for an upgrade, but I'm worried because I can't try it with PDI.

There are two things I don't understand about Exclude Table.

The first is how to register the Exclude Table.

The official documentation says to click the New button and enter the table name.

My perception is to enter the table's "Column_name" in the "Name" field above, but isn't it wrong?

The second is about the table to be excluded.

I don't want to copy the following table to the target instance.

Is it possible to exclude all of these tables? Also, are there any tables that should be excluded?

• Tables you want to exclude
  incident, incident_task, problem, problem_task, change_request, change_task, sys_user, sys_user_group, user_multifactor_auth, notification, knowledge

[Arjun Ayyappan · Accepted solution]

Hi,

1. You would need to enter the table name in "Name" column when creating an exclude list. For example to exclude user_multifactor_auth table enter "user_multifactor_auth".

2. You can add any number of tables to the exclude list. Please note that excluding will only prevent data from being copied from source to target. You may also want to add the tables to preservers if you want to retain the data in target.

Here are some documents you may find helpful.

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

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

Regards,

Arjun

[d-aizawa]

Thank you so much for your kindness.

One thing I was curious about in your answer.

Does that mean that if you want to erase the cloned data someday, you need to set something?

If there is a description in the document, please include the URL.

Thank you!