Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nathans
Aged Yak Warrior
938 Posts |
 Posted - 2005-04-25 : 19:42:21
|
| Guys,How are you all populating your development environments? We have a medium sized db in production (~150 Gb) and so far the company has been doing full restores to the dev environment every so often to refresh with the most current production environment. This process take a long time and is disruptive to our development. Im just curious how others are tackling this issue. Is a 3rd party tool available that can assist in creating "subset" .bak files that only contain a predetermined amount of data? I havent seen much out on the web.I have started developing a process by which we can define the tables in the database and the type of data we want returned (lookup table vs. driving table) but why reinvent the wheel if a process already exists, right? Anyways, thanks for ANY input on the subject.- Nathan |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-04-25 : 20:05:58
|
| If you have the disk space on your development server, you might try restoring the database to a new database name, doing whatever else you have to do to prepare it, then rename it when you are ready, and drop the old development database. That way, you could continue to use the current development database until the new one is completely restored. If you are not doing any development work on the weekend, maybe you could schedule it as an automatic job.As for getting subsets, you might look into using DTS to bring selected pieces of data into your development database from production. It certainly is not automatic, and you have to do a lot of work to get it setup, but it does work. Then setup some scheduled jobs to bring over data as you need it.I doubt if there is anything that could be done with a .BAK file, because it is a fairly low level page by page copy of the database.CODO ERGO SUM |
 |
|
|
|
|
|
|
|
Creating development subset