What is the fastest method to create a new database from a template ?

Posted by Locksfree on Stack Overflow See other posts from Stack Overflow or by Locksfree
Published on 2010-03-24T08:36:33Z Indexed on 2010/03/24 8:43 UTC
Read the original article Hit count: 278

Filed under:
|

We are creating databases on demand and the databases can be created from different templates. All templates have the same structure but different data. The data contained by the templates is small.

What is the fastest way to create a copy of the database:

  1. Backup/Restore
    1. Using T-SQL ?
    2. Using SMO ?
  2. Create a new database from a scripted version of the template and then fill in the little data required ?
  3. Other ?

© Stack Overflow or respective owner

Related posts about mssql

Related posts about database-restore