copying stored procedures in SQL Server 2005?
in [Server Configuration]
|
Prev: msdb
Next: xp_readerrorlog error
From: Dean Slindee on 5 Mar 2008 22:22 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.. "Uri Dimant" <urid(a)iscar.co.il> wrote in message news:uBLTdbofIHA.4140(a)TK2MSFTNGP04.phx.gbl... > Dean > multiple stored procedures > > > "Dean Slindee" <slindee(a)charter.net> wrote in message > news:2B130575-80A1-40DA-A83C-C5A71D2AA39F(a)microsoft.com... >> Does this procedure copy one stored procedure at a time, or multiple >> stored procedures? >> >> "Uri Dimant" <urid(a)iscar.co.il> wrote in message >> news:OwmbByffIHA.1900(a)TK2MSFTNGP02.phx.gbl... >>> 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 >>> >>> >>> >>> >>> >>> >>> "Dean Slindee" <slindee(a)charter.net> wrote in message >>> news:7D625CC4-05B4-4BF6-87F1-BA670532B06B(a)microsoft.com... >>>> 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 >>> >>> >> > > |