Create an empty database using an existing database

• Gy Song

  SSC-Addicted

  Points: 449

  More actions

  September 8, 2008 at 1:43 pm

  #123315

  I think there is a simple way to create an empty database that has the same database objects except data from an existing database. Does anybody know?

  Thanks,

• Pam Brisjar

  SSChampion

  Points: 12094

  More actions

  September 8, 2008 at 1:46 pm

  #868703

  Right-click, Tasks, Generate Scripts, select the objects you want to script out.

• Gy Song

  SSC-Addicted

  Points: 449

  More actions

  September 8, 2008 at 2:46 pm

  #868732

  That's it. Thanks.

  For others who are looking for similar answers this article might be helpful: http://www.sqlservercentral.com/scripts/T-SQL/61312/ (how to empty database)

  Thanks again for your reply.

• Gy Song

  SSC-Addicted

  Points: 449

  More actions

  September 8, 2008 at 2:47 pm

  #868735

  I've nver heard about Apex SQl Diff, but will take a look.

  Thanks,