Copy SQL stored procedure from local to live database

25 pts.
Tags:
SQL
Stored Procedures
Hello, I want to copy multiple procedures from a local database to a live database?


Software/Hardware used:
SQL Server 2008
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    Sounds like you are asking us if you want to do something...

    Please provide more details and let us know what exactly you need help with.

    Thanks,
    84,670 pointsBadges:
    report
  • AjitK29
    • Right click on database
    • Tasks
    • Generate Scripts
    • Select the objects you wish to script
    • Script to File
    • Run generated scripts against target database

    2,545 pointsBadges:
    report
  • vikasbhatt
    Thanks but it is done.
    25 pointsBadges:
    report
  • vikasbhatt
    I need a tool which copy all the tables and its data, procedures etc on webserver
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: