Using production data in staging

  1. Share your production database with the staging application, which would allow read/write access to the database from your staging enviroment. In this scenario, we strongly urge you to look closely at how you will avoid writing incorrect data to the production database.
  2. Setup a master/slave database on the production application and connect to the slave from the staging application. This would only allow read access, so may not be suitable.
  3. Use the database import feature to copy your production database to the staging database. This is perhaps the best alternative, as you’re not working directly with your production database.