Best way to copy production DB to Development DB

• John Gundrum

  SSC-Addicted

  Points: 427

  More actions

  April 27, 2003 at 10:53 am

  #80081

  What ways are there to keep a development DB up-to-date with production data?

  Thanks,

  John Gundrum

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  April 27, 2003 at 1:27 pm

  #455475

  If you are after the full database, you can run a backup/restore.

  For coping data from tables, you can use dts or bcp.

  Steven

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  April 27, 2003 at 2:31 pm

  #455479

  Backup/restore works well. You could use replication, but I think that is more than is needed in most cases.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter