How to store SQL Server job code and stored procedure in SVN Repository

  • 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

  • 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[/url]
    Learn Extended Events

  • How to script the job as drop create?

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

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