Post reply

copying multiple store procedures across databases

  • June 3, 2010 at 8:44 pm

    #236069

    Hi all,

    I came across a scenario where i have to copy the stored procedures across the databases.can you suggest me the best approach. I have almost 200 stored procs in my database.Thanks in advance.

    regards.

  • June 3, 2010 at 8:58 pm

    #1176288

    Hi,

    In SQL Management Studio right click database-> tasks->Generate scripts. Select "Stored procedures" as Object Types and don't forget to script objects permissions under Script Options.

  • June 3, 2010 at 9:07 pm

    #1176289

    thank you.

  • June 3, 2010 at 9:44 pm

    #1176297

    You just want to copy, the SP's or any planning for replication kind of ?

    If copying alone, then as suggested generate the script file and execute it 🙂

    enjoy!!

  • June 4, 2010 at 10:15 am

    #1176618

    hi,just trying to copy the sp's.Thanks for ur response.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply