March 21, 2012 at 8:19 am
Hi..
I have looked all over the net and could not find an answer of help. I need to create a dev, test and staging environment off of my production SQL Server 2008 R2 database. Each will not be an "exact" clone of production and may have different versions of certain tables. I need to script this task so it can be automated. Currently it is done manually and human error is involved. We have an Oracle environment where this same type of process has been fully scripted and automated. I just do not know how to do it in SQL Server as I am not as familiar.
I greatly appreciate any suggestions on this issue!
Thanks,
NS
March 21, 2012 at 9:02 am
You can automate RedGate's Compare and Data Compare products to do that kind of thing for you, if I'm not mistaken.
SSIS can also merge data changes for you, and you can schedule runs on that.
Replication might be an option as well.
Personally, I don't like automating copies from Production to other environments, because of the tendency to end up with data-security issues.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply