Copying data

• yaip

  SSCrazy

  Points: 2656

  More actions

  April 28, 2006 at 11:54 am

  #169246

  I've got two DBs in the same SQL instance. They are named TST and PRD. I am using 2.0 so there are many ASP generated tables also.

  Every once in a while I want to refresh data from PRD to TST. But I don't want to copy the data from ASP tables.

  What is the easiest way to do so?

• May 1, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  May 1, 2006 at 9:49 am

  #635153

  Easiest way is to buy Data Compare from Red Gate. Easily with the $300 in time it would take to develop scripts.