Copy Databases objects
-
Hello, We are in the process of copying over our live database over to a new more robust server. Is there a script/utility to create all the database objects? Thanks!
Management Studio has scripting capability. One example walkthrough over here: 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/[^]. The example is from version 2005 and if you use 2008 the tool is slightly better (includes more objects).
The need to optimize rises from a bad design.My articles[^]
-
Hello, We are in the process of copying over our live database over to a new more robust server. Is there a script/utility to create all the database objects? Thanks!
The Database Publishing Wizard[^].
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me
-
Hello, We are in the process of copying over our live database over to a new more robust server. Is there a script/utility to create all the database objects? Thanks!
If you are just moving the database do backup/restore or detach/attach. These create the tables for you.