September 22, 2003 at 1:42 pm
Hi,
Is there a standard for setting up Testing/QC Environments?. We want to be able to set up Test/QC environments as OFTEN as possible and also as quick as possible. Currently we do backup/restores every month into Test/QC boxes. But our production file is getting HUGE and its not feasible to backup the entire database to create these environments. Please educate me on this topic.
Thanks
September 22, 2003 at 3:05 pm
That is really the best option for doing this. How big is big?
You could use something like RedGate's Compare utilities and "synch" the schemas, not sure about data. They have a data tool, but not sure how it works for this.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 22, 2003 at 5:18 pm
DB size is 50GB.
I was thinking more like creating a TEST database and copy all the schema/objects into this database, then schedule a snapshot replication every week.
Not sure even if that helps me.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply