Copy Database

• anakin

  SSC Veteran

  Points: 272

  More actions

  January 14, 2003 at 1:57 am

  #159322

  Hi,

  what's the easiest mode to reply a database named "template" to a new database ?

  I want reply structure and data, but not the autoincrement field values if aren't contiguous.

  Thanks, anakin

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  January 14, 2003 at 10:38 am

  #446310

  There isn't an easy way to avoid the autoiuncrement fields. You'd need to script something for these.

  To copy the database, a backup and restore is the easiest way.

  Steve Jones

  sjones@sqlservercentral.com

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

  http://www.dkranch.net