6 Refreshing a Rock Development Environment from Production Shared by Tony Visconti, College Church 2 years ago 14.0 General Intermediate OverviewA refresh process has three high level steps. These are described in detail in the creating a sandbox resource found on the Alpha/Beta Testers PageCopy the Production database to the Development serverRun a SQL script to prepare the Production database copy for use on the Development serverCopy the Production "code" to the Development serverSpecifically, we are taking a copy of the IIS wwwroot folder and updating the web.ConnectionStrings.config to point the Development database (the one just copied over from production)Additional ResourcesHere are some additional resources provided by Rock Community members for consideration when drafting a refresh process more specific to your environment.Shawn Ross offers a concise step-by-step process that builds on the creating a sandbox resource: https://calvary.church/page/914?Item=452This resource is frequently pointed to when people in the community ask about how refresh a Development Environment with Production data.Derek Mangrum offers a unique look at "On-Premise Hosting a Test Environment Using Production Data" you can access with the content subscription. Derek makes use of several PowerShell scripts to automate the process.Jeff Richmond has shared his sql script for preparing the production database and updating html content, content channel items, lava shortcodes and much more.Here is a link to my process I created after reviewing the resources above and collaborating with Kelley Langkamp over at KFS. My version is similar to Derek's but geared toward hosting in Azure instead of on-premise.