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

[Tanushree Maiti]

Hi @Lucky1 

Please analyze and identify which configurations should not be overwritten in Dev from Prod during the clone activity.

For example:

• User table
• Group table

There are several tables that may overwrite the existing integration configurations in Dev. This means that after the clone is completed, endpoints and OAuth credentials may need to be updated manually.

You will need to decide whether these tables should be added to the exclude list or post cloning , if the configurations will be updated manually post-cloning.

[Lucky1]

Hello Thanushree,

Thanks for your response.

Yes, that is what I am actually looking to understand.

As I mentioned there are two tables, Preserve Data and Exclude tables.

So can we make use of it instead of taking some tables XML data back-up?

If so, how can we use those two tables if I have to avoid overwriting of some tables data like, credentials, Users, x509 Certificates, etc, etc.

Thanks,

Lucky

[Tanushree Maiti · Accepted solution]

Hi @Lucky1 

This KB : KB0717012 How Table Exclusion and Data Preserver settings affect clone results  is for you.

Note: taking backup is always good before starting this activity even after you have updated exclude and preserver list.

[Lucky1]

Hello Tanushree,

Very good article you have shared.

Thanks for that. Let me get back to you once gone through it.

Regards,

Lucky