+ Start a Discussion
Arup SarkarArup Sarkar 

Application data migration from Production to Sandbox

Hi:

 

I would like to know what is the best possible approach to migrate data from production to sandbox on a regular basis. Once we refresh sandbox with production metadata the application data gets erased, we have a real challenge to bring the data back to sandbox with a specified timeframe.

 

Our Sandbox is not a full sandbox.

 

Regards,

Arup

CaffeineCaffeine

Arup,

Without a full sandbox, you will probably not be able to bring all data down to a Config-Only sandbox because the data storage is much more limited in a Config-Only than in Production.

 

This being said, if you want to bring down partial data from Production on a regular basis, your best bet is:

- Hava good ETL tool like Informatica Cloud or Boomi

- Have a local Oracle or SQL*Server database to act as a middleman.

- Identify the data sets you want to bring down.

- Set up sources, targets and a job to pull down the data sets to your local database

- Set up sources, targets and a job to push data to your config-only sandbox.

 

The order in which you pull data from prod is not significant, but the order in which you insert/upsert data to the sandbox will be significant.  Users before Accounts before Opportunities before Contacts, for example