September 22, 2003 at 10:56 am
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 24, 2003 at 4:56 pm
Hi,
Not an expert by any means, but..
I think the truest testing environment will be an identical mirror image of your database, as you are doing with backup/restore. I don't follow why you need to do a separate backup for this tho', don't you have a routine backup for data recovery purposes that you could use for the restore?
You may also be able to set up replication to do this to your testing server instead of backup/restore.
If the size of the database is the issue, rather than the time/performance to do the backup, you may want to look at breaking your testing up into smaller pieces. Rather than testing the whole, for example testing each of your stored procedures separately. Then for each test you will only need to bring across the tables that the current stored proc references. You could set up DTS packages to do this. These can then be re-run as frequently as you require to update the data.
HTH
Chris
Edited by - cwedgwood50 on 09/24/2003 4:59:54 PM
September 29, 2003 at 10:06 am
I haven't tried this, but youmight be able to use the Red Gate tools (see the bottom banner ad) to move the strucutre and then a subset of data over.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply