Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to store SQL Server job code and stored procedure in SVN Repository Expand / Collapse
Author
Message
Posted Friday, March 22, 2013 12:13 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 20, 2014 2:51 PM
Points: 32, Visits: 91
what is the best way to store SQL Server jobs code and stored procedure in SVN Repository so that other team members can access it as well


Thanks,
Blyzzard
Post #1434455
Posted Friday, March 22, 2013 12:24 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:18 PM
Points: 17,824, Visits: 15,756
Use stored procedures for any jobs and store the stored procedure in SVN

or

Script the job as a drop create and store that statement in SVN.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1434465
Posted Friday, March 22, 2013 12:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 20, 2014 2:51 PM
Points: 32, Visits: 91
How to script the job as drop create?
Post #1434481
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse