Wednesday, December 10, 2008

Script to Copy database schema and all objects

Have you every created a database and after finishing it all and putting test data in it, you realize now you need an empty one or need to allow someone else to create one. Well a Greek SQL God just sent me a link to do just that. The link to the article is below:

http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/

Hope this helps you and if you have any tips, tricks, resources that you think may help others in this group please email them to susan@clinchportal.com and I will post them.

No comments:

Post a Comment