SQL Server equivalent for PG Dump

• Walter Tucholski

  Ten Centuries

  Points: 1262

  More actions

  October 9, 2009 at 2:40 pm

  #136445

  Does anyone know of a method or tool like PG DUMP for Postgres. I am using SQL 2008 and would like to script the whole database including the data into one file so that I can later run the script to recreate the database as it was? The purpose is to capture a test bed and recreate the database at will.

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  October 9, 2009 at 3:14 pm

  #1064369

  Use BACKUP and RESTORE. You can refer to SQL Server 2005 Books Online for detailed information on how to do this, starting with the link below.

  SQL Server 2005 Books Online (November 2008)

  Backing Up and Restoring Databases in SQL Server

  http://msdn.microsoft.com/en-us/library/ms187048(SQL.90).aspx