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.