I recently set up a new sql 2005 standard edition and planning to mirgrate our production sql 2000 data. but only the tables were migrated from the copy data or import / export task. I cannot find a way to recreate the store procedures and views on the new server without create one view and one store procedure at a time unless all hundreds of views and procedures were rescripted. can anyone help
Thank
Andy Wong
awong@.virginiadare.com
Right click the database > Taks > Generate Scripts, this will give you the option to put it in one output-file
Jens K. Suessmeyer
http://www.sqlserver2005.de
No comments:
Post a Comment