Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Sandbox environment for customers Expand / Collapse
Posted Friday, April 19, 2013 8:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, October 23, 2015 10:24 AM
Points: 28, Visits: 201
I am looking for ideas on how to solve few problems we have with our customers creating sandbox environments.

We are running an ASP.NET web application along with a windows server and a SQL Agent job configured to run against a production SQL Server database. Customers can create a parallel setup and restore the production database to a new instance. Once this is complete everything works great and they get full functionality as planned.

Our problems start when the sandbox application starts performing actions that should only happen in the production DB. So we may have schedule tasks that could export to the same folder location and file, send emails and or transfer data to other production sites. All of these should be functional need to be functional in the sandbox application but it should only be running newly created tasks or configuration that had been set up after the restore took place.

I can come up with a unique solution for each of the areas where I have problems. I can write a script that could be run to disable or change all of these areas, but it is a manual step that would depend on the customer running when the environment is restored. I am hoping for a more global solution of preventing or disabling things in a sandbox environment. Even something like a restore trigger that could automatically run a script.

How do others handle such issues?
Post #1444427
Posted Friday, April 19, 2013 8:35 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 6:40 AM
Points: 699, Visits: 4,345
If you can, script these actions, ie., put these "must change items" in a script, then parameterize and script the entire restore operation and include the t-sql restore inside of this.

to properly post on a forum:
Post #1444456
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse