create dev database

cmitchellcmitchell Posts: 3 New member
edited February 2, 2015 10:20AM in SQL Data Compare 11
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?


  • Hi Colin,

    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?
    Software Engineer
    Redgate Software
  • cmitchellcmitchell Posts: 3 New member
    Thanks much, that will get me started.
  • No problem. If you have any more questions, please ask!
    Software Engineer
    Redgate Software
Sign In or Register to comment.