How to copy only the structure of database from one instance to another.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  January 15, 2015 at 3:25 am

  #302385

  Hi All,

  I want to make copy of a database without the data. I want all the objects to be copied but without the data in the tables.

  Whats the best way to do it ?

  Thanks,

  San

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  January 15, 2015 at 3:46 am

  #1770374

  Right-click database, go to "tasks" and then "generate scripts".

  There you can script everything out.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP