Home
Topics
Microsoft SQL Server Platforms
Microsoft SQL Server 2005
Copy stored procedure between SQL Server 2005 databases

Copy stored procedure between SQL Server 2005 databases

Can you tell me how to copy stored procedures (16155) from one database to another on the same SQL Server 2005?

Requires Free Membership to View

Login

By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

On SQL Server 2005, you can choose to script the stored procedures. Right click the database, then Tasks → Generate Scripts. Step your way through the wizard until you get to the option to select object types and just choose Stored Procedures. On the last page of the wizard, you can choose to send the script to a new query window. You'll need to change the database name at the top of the script and execute it against the other database.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- Yukon

This was first published in December 2007

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Practical approach, not dazzle, needed on mobile BI applications
  
  To be successful, mobile business intelligence projects must provide useful capabilities, not just cool-looking apps, BI managers and analysts say.
- Business intelligence management should mostly be about the business
  
  The best way to manage BI projects is to involve business users in everything, from defining needs to creating reports and dashboards, analysts say.
- Lean but agile BI, data warehousing turn IT engineering into craftsmanship
  
  Agile BI and data warehousing begins with an assumption so big, it could derail the process. But a TDWI keynote speaker may have a solution.
Data Center
- Open Compute Project brings open source to server design
  
  The Open Compute Project pushes new server hardware models developed to ease deployments and lower costs for large data centers.
- New York Times article on data center power consumption draws ire
  
  The New York Times' article cast data centers as power-hungry behemoths, drawing a stern and swift response from IT pros.
- Data center association AFCOM names Tom Roberts new president
  
  After ten years, Jill Yaoz steps down as data center association AFCOM's president. Tom Roberts, a 30 year data center veteran takes her place.
Data Management
- New Gartner Magic Quadrant finds demand rising for data quality tools
  
  Organizations are using data quality tools to support a growing range of use cases, according to a new Gartner Magic Quadrant report.
- VoltDB, Actuate team up to offer speedy 'big data' management
  
  VoltDB and Actuate have partnered to offer rapid-fire 'big data' management, plus more data management technology news from around the Web.
- Misconceptions holding back use of data integration tools
  
  Integration software has matured in recent years, but consultant Rick Sherman writes that many IT managers aren't aware of the increased capabilities.
DataManagement UK
- Dynamic Markets: CFOs see worth in data on balance sheet
  
  About 20% of UK companies are assigning a financial value to their data, according to research sponsored by SAS. But only 16% of UK companies have a formal data management strategy.
- Data ethics: Author warns of ethical pitfalls of data collection
  
  Heedless data collection in business analytics programmes is breeding moral hazards, according to author Frank Buytendijk.
- Data visualisation success hinges on solid storytelling skills
  
  Tableau's Jock Mackinlay explains why data is inert and worthless without the twin practices of visualisation and storytelling.
Oracle
- Faceoff: Oracle Exalytics, a true appliance, surpasses SAP HANA
  
  Oracle Exalytics has backwards compatibility, innovative in-memory database features and is a true appliance, making it better than SAP HANA.
- Oracle Database 12c to be announced at OpenWorld
  
  The first major upgrade to Oracle's flagship database product in three years will include features around the cloud, tuning and automation.
- Oracle on Itanium customers breathe sigh of relief
  
  IT pros running Oracle on Itanium are happy Oracle will now support software on Itanium, but a crucial decision still awaits them down the road.
Content Management
- First look: SharePoint 2013 adds apps, simplified user interface
  
  Microsoft has built many new features into SharePoint 2013, including developments in social media, apps for customization and simplified administration.
- Expert offers tips to craft effective enterprise social media strategy
  
  Organizations must assess their enterprise social media strategy to see whether social technology supports their business, says AIIM's Jesse Wilkins.
- From the Editors: No magic to effective WCM; just careful planning
  
  For Web content management deployments to be effective, they require careful planning and implementation for greater ROI and targeted user experience.
Windows Server
- Revisiting DCPromo in Active Directory: what's changed?
  
  Admins might have experience with the DCPromo tool in Windows Server's Server Manager. Learn about its history and where it's going.
- Subscribe to Modern Infrastructure
  
  Guiding IT managers making strategic infrastructure decisions while keeping an eye toward macro trends such as cloud computing and consumerization.
- Five quick links: 2012's top Windows Server management tips
  
  The most-clicked tips on Windows Server administration included old and new subjects: from Remote Desktop Gateway to IIS 8.

All Rights Reserved,Copyright 2005 - 2012, TechTarget