How can I back up stored procedures in sql server database?

sd_farsd_far Posts: 1 New member
How can I back up stored procedures in sql server database?
Tagged:

Answers

  • Alex BAlex B Posts: 1,158 Diamond 4
    Hi @sd_far,

    Do you mean aside from a FULL backup of the database?  They will be included in a FULL backup of the database, but if you just want the text of the stored procedures there are several options.

    With our tool SQL Compare you can save the creation script for the stored procedure objects to a folder by setting up a comparison to an empty folder, filtering the comparison just to stored procedures, selecting all differences and then deploying them.

    If you wanted an integration to your source control system from within SSMS you could use our SQL Source Control product which you can filter similarly to the above.

    Alternatively you can just script out the stored procedures in SSMS and there are likely other options as well.

    I hope that helps!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.