SQL Express - Define my database as MODEL and create new databases from it
Posted on 2009-05-13
Hello everybody again,
We have a framwork from which we devise websites for customers and the framework runs on top of a SQL Server Express database.
I'd like to know what would be the quickest way to define my database as a Model database and create duplicates of this database to deploy other websites.
As of now I run a .sql file which populates an empty db and inserts the needed data to it.
Recently we made some upgrades to our framework and the ammount of data to be inserted on the db grew quite a lot, thats why I think theres gotta be an easier and faster way of doing this, considering that I have administrator's access to the database server instance.