How can I back up stored procedures in sql server database?
sd_far
Posts: 1 New member
in SQL Backup
Answers
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
Have you visited our Help Center?