You need to sign in to do that
Don't have an account?
Arup 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
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