By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

SQL Server 2005 copy objects

P: n/a
Jer
I have two databases on the same SQL Server 2005 server. There are
views and stored procedures in one database I'd like to copy to the
other one. What is the recommended way to accomplish this?

Thanks!
Jerry
Sep 4 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Jer (je***********@saic.com) writes:
I have two databases on the same SQL Server 2005 server. There are
views and stored procedures in one database I'd like to copy to the
other one. What is the recommended way to accomplish this?
To have all your source code under version control and build databases
from sources so you know what you build.

Else you could select all procedures in Object Explorer Details (F7) and
select a scripting alternative from the context menu. Same with views.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Sep 4 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.