 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008copying stored procedures in SQL Server 2005?
Is there a quick way to copy a set of stored procedures in SQL Server 2005 from one database engine to another, as quickly as using DTS in SQL Server 2000? Other than restoring from a backup. Thanks, Dean S Dean In objects explorer details select stored procedures you want to copy to, then right click and Script Stored Procedure as --- CREATE TO --- new query, make sure that you under scope a target database and press F5 > Is there a quick way to copy a set of stored procedures in SQL Server 2005 > from one database engine to another, as quickly as using DTS in SQL Server > 2000? Other than restoring from a backup. > > Thanks, > Dean S Does this procedure copy one stored procedure at a time, or multiple stored procedures? > Dean > In objects explorer details select stored procedures you want to copy [quoted text clipped - 7 lines] >> Thanks, >> Dean S Dean multiple stored procedures > Does this procedure copy one stored procedure at a time, or multiple > stored procedures? [quoted text clipped - 10 lines] >>> Thanks, >>> Dean S Uri One answer to my question could have been: Create a new SSIS package using the "Transfer SQL Server Objects" tool. In the tool, fill in the parameters and connections and execute the package. This is conceptually similar to the former DTS process. One just has to keep redefining a "temp" SSIS package, or create several "work" packages, per database. Your process would be more useful for a quick transfer; no package required. However, I have been unable to accurately follow your brief instructions. Would you please expand on the instructions with numbered bullet points? Like: 1. In SQL Server 2005 Management Studio, click on the Source database table's Stored Procedures folder. 2. Select the stored procedures to be copied (I can only select one at a time). 3. Right click and select Script Stored Procedure as CREATE TO: 4. Now, click on the Destination database table's Stored Procedures folder 5. Press F5 at.. > Dean > multiple stored procedures [quoted text clipped - 13 lines] >>>> Thanks, >>>> Dean S > Is there a quick way to copy a set of stored procedures in SQL Server 2005 > from one database engine to another, as quickly as using DTS in SQL Server > 2000? Other than restoring from a backup. > > Thanks, > Dean S I suggest that you can find a stored procedure named dbo.sp_generate_script. Using dbo.sp_generate_script, you can get all stored procedures in a database. GOOD LUCK. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.