April 26, 2007 at 5:58 am
We're building an application for a client who wants to be able to connect that app to the live db or have the option to create and connect to a sandbox database. There are several users that would be able to create their own copies of these sandbox dbs and they can create many based on a point in time. We will put a limit to how many sandboxes they can have and a "cleanup old sandboxes" capability.
I figured I would write a bunch of script to move data but then I would have to maintain the script if anything changed in the live db (or it would be broken).
I'm still in the exploratory stages of this functionality and I'm wondering if you guys have ever seen/implemented such a functionality and how did you do it. I'm just looking for ideas at this point; so all are welcome.
Sorry so darn wordy; I have typing diareaha 🙂
Blaise
April 26, 2007 at 11:52 am
What about using SQL Server 3005 Snapshots? That is if your running Enterprise Edition.
April 26, 2007 at 12:19 pm
I haven't read much about snapshots yet. I will explore that option.
Thanks for the reply.
April 27, 2007 at 6:13 am
sounds like you should explore the MS VSTS/DataDude
http://msdn2.microsoft.com/en-us/teamsystem/aa718807.aspx
You can script out [from LIVE] and create sandboxes [on developer's PC] with the metadata. You would normally use the data generate facility to fake up some data [say within regex rules], but you can also do custom population [which could include getting data from LIVE]. Horses for courses!
HTH
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply