• To initially get your database structures back into sync I would use Redgate Compare. After that, whatever process you use to change the structure of your main database must also include the process to update the staging database.

    Here, we have environments for testing and QA that replicate the structure of Live, and any changes to databases required for Live (including staging, data warehouses and so on) are scripted and tested in these environments prior to Live deployment.