Create empty database with their structures from existing DB

• ssk0507

  Mr or Mrs. 500

  Points: 533

  More actions

  October 24, 2011 at 5:14 am

  #261867

  Dear All,

  For Migration purpose,i want create empty database with their structures(not data) from existing database. Means mirror structure of existing database.Please help me out.

  I am new to this kind of work.for that any scripts are there if there please post or give me brief description how to do that.

  Regards,

  Satish

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  October 24, 2011 at 5:45 am

  #1398623

  Read this article

  http://sqlblog.com/blogs/kalen_delaney/archive/2007/11/21/cloning-in-sql-server-2005.aspx

  It contains detailed step by step instructions on how to do what you want to do

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]