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: 284
mssql
|database-restore
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:
- Backup/Restore
- Using T-SQL ?
- Using SMO ?
- Create a new database from a scripted version of the template and then fill in the little data required ?
- Other ?
© Stack Overflow or respective owner