How to merge data from one environment to another

(0) Share

Report

Posted on by Simone Colaci

Hi,

I have two environments in the same tenant, a sandbox environment and a production environment. I need to merge specific data (only some fields) between two environments (from sandbox to production). For example, I have one contact with the same firstname and lastname in both environments, but with different GUUID. I would like to update the contact present in the production environment with some information present in the sandbox environment. After this operation, delete the contact from the sandbox environment. I should repeat this operation for 60k contacts.

Can you recommend me about the automatic procedures or tools to do this?

I hope you can help me. Thanks in advance.

Regards,

Simone

All responses (1)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: How to merge data from one environment to another

Hello Simone,

I would recommend using SSIS with the KingswaySoft adapter. I understand this is not exactly the answer you were looking for but this is the best tool to implement what you need.