create dev database
cmitchell
Posts: 3 New member
HI,
We have a large (600GB) data warehouse db and i'd like to replicate the last 6 months of data to a development server. What is the best way to go about the initial copy? The target is empty so there isn't really anything to compare. In terms of performance where is the best place to run the compare from?
Thanks,
Colin
We have a large (600GB) data warehouse db and i'd like to replicate the last 6 months of data to a development server. What is the best way to go about the initial copy? The target is empty so there isn't really anything to compare. In terms of performance where is the best place to run the compare from?
Thanks,
Colin
Comments
If the compare is run from either the target or the source, at some point the data is going to have to be copied over a network whether it's either during a retrieval or a deployment. The big performance factor is going to be the specification of the machine you are using. You may also want to consider using the SQL Data Compare command line to creating a comparison and deployment command in a batch file that you can then schedule to run at a time when the server is experiencing its least activity.
One other thing to bear in mind - by default, SQL Data Compare stores temporary files in the %TMP% folder, which by default is in your Windows profile folder, so you'll need to make sure your hard disk has enough space on it. If not, then you can tell SQL Data Compare to use another location by creating a new environment variable named RGTEMP that points to the location you want to use as the temporary folder.
Does that help?
Redgate Software
Thanks much, that will get me started.
-Colin
Redgate Software