468,242 Members | 1,474 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

SQL Server 2005 copy objects

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
1 1951
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.

Similar topics

reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.