database-cloning

How to have a "master-structure" database with "children-data" databases in SQL SERVER 2005???

I have been googling a lot and I couldn't find if this even exists or I'm asking for some magic =P Ok, so here's the deal. I need to have a way to create a "master-structured" database which will only contain the schemas, structures, tables, store procedures, udfs, etc, everything but real data in SQL SERVER 2005 (if this is available ...

what is database cloning?

had been looking towards this "Database Cloning" quite many times.. is it anything different from simply creating a copy of the database... please tell me keeping MySQL in mind... ...

How to copy everything except data from one database to another?

Hi, In T-SQL (Microsoft SQL 2008), how can I make a new database which will have the same schemas, tables, table columns, indexes, constraints, and foreign keys, but will not contain any data from the original database? Note: making a full copy, then removing all data is not a solution in my case, since the database is quite big, and s...