Clone Activity Question

[Lucky1]

Hello all,

We are going to clone our DEV instance, and I have taken back-up of below tables. 

1. System Properties (sys_properties)
2. Authentication Configurations (sys_auth_profile)
3. Basic Auth Configuration (sys_auth_profile_basic)
4. Application Registries (oauth_entity)
5. Oauth Entity Profiles (oauth_entity_profile)
6. Oauth Entity Profile Scopes (oauth_entity_profile_scope)
7. Oauth Entity Scopes (oauth_entity_scope)
8. Oauth Credentials (oauth_credential)
9. X509 Certificates (sys_certificate)
10. REST Messages (sys_rest_message)
11. Protocol Profile (sys_protocol_profile)
12. HTTP Methods (sys_rest_message_fn)
13. HTTP Headers (sys_rest_message_fn_headers)
14. Variable Substitutions (sys_rest_message_fn_parameters)
15. Scripted REST APIs (sys_ws_definition)
16. Scripted REST Resource (sys_ws_operation)
17. Scheduled Script Executions (sysauto_script)
18. Scheduled Jobs (sysauto)
19. Schedule (sys_trigger)
20. Credentials (discovery_credentials)
21. Discovery Schedules (discovery_schedule)
22. Data Sources (sys_data_source)
23. Import Sets (sys_import_set)
24. Transform maps (sys_transform_map)
25. Field Maps (sys_transform_entry)
26. Transform Scripts (ys_transform_script)
27. Scheduled Data Imports (scheduled_import_set)
28. Mid Servers (ecc_agent)
29. Mid Server Configuration parameters (ecc_agent_config)
30. Mid Server Capabilities (ecc_agent_capability)

Apart from all these, I have also taken back-up of Customer Updates (Local Update sets) as well.

Secondly, in the Preserve Data and Exclude Tables, I see there are some tables already added.

And while raising the clone request, I have checked the check-boxes that are required.

So, my question is am I going in a right way by taking the back-up of those 30 tables?

And next, can someone tell me how exactly, Preserve Data and Exclude Tables work?

Because we seen some integrations were broken when we clone our UAT instance.

Please help.

Regards,

Lucky

[Lucky1]

So Tanushree,

I have listed some tables in the question, right?

so, if I don't want to overwrite the data from Source instance, then I need to include those tables in both Exclude tables and Data Preservers table.

Am I right??

If I do so, then I don't need to import the XMLs again in to the target instance.

Right?

Regards,

Lucky

[BharatC]

Hello @Lucky1 

https://www.servicenow.com/community/developer-forum/simple-understanding-of-data-preservers-vs-data...

https://www.servicenow.com/community/developer-forum/difference-between-preserve-and-exclude-data/m-...

https://www.youtube.com/watch?v=qhhiUjHCH5I

If the provided solution is useful/working, please Accept as Solution and hit the Helpful.

Thanks & Regards,
Bharat Chavan

[Dr Atul G- LNG]

Hi @Lucky1 

These images help you to understand the concept you looking for.