copying stored procedures in SQL Server 2005?
in [Server Configuration]
|
Prev: msdb
Next: xp_readerrorlog error
From: Dean Slindee on 4 Mar 2008 10:23 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
From: Uri Dimant on 4 Mar 2008 08:36 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
From: DDD on 4 Mar 2008 10:06 On Mar 4, 11:23 pm, "Dean Slindee" <slin...(a)charter.net> wrote: > 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.
From: Dean Slindee on 5 Mar 2008 00:06 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 > >
From: Uri Dimant on 5 Mar 2008 01:06
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 >> >> > |