Post reply

how to backp or copy my stored procedures to another server

  • May 12, 2004 at 10:35 pm

    #85016

    Hi all

    I have  about 68 SP's created need to transfer to  a new sql server  ; associated db is in new server as it is resored now.

    Can i just backup them like db's  or to backup stored procedures is it only export method?

     

    pls suugest me best way to do it .

     

    Thanks

    singa

  • May 13, 2004 at 9:01 am

    #506334

    hi Chami Rstnayake

    these are the ways to can do

    1) Backup the database and restore the database

    2) using logical backup i.e exporting functionality

    3) generate the script and exectue it on another server

  • May 17, 2004 at 6:27 am

    #506633

    If the new server is on your Lan you could also use DTS to transfer the SP's.

  • May 17, 2004 at 8:42 am

    #506662

    If you have Enterprise Manager, you could script the SP's and then play back the script on the new server.

    To script, right click on the database, select "All Tasks", then choose "Generate SQL Script".  Then click on the "Show All" button, then choose "All Stored Procedures"

    Dana

    Connecticut, USA



    Dana
    Connecticut, USA
    Dana

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

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