Post reply

Looking for a good source control system...

  • July 5, 2011 at 4:49 pm

    #240864

    Hey all,

    My team and I are looking for a source control system that best fits our need. Our need concerns SSRS reports, basically to keep everything in one central place and being able to check out/check in reports. This way two or more people are not working on the same report at the same time...etc.

    Eventually we would like to establish a similar architecture for ETL development (Oracle PL/SQL).

    I have (so far) found Apache Subversion, Team Foundation Server, and Visual SourceSafe.

    I will continue my research on all these tools, but I wanted to reach out to you guys for any input and recommendations.

    I greatly appreciate the help!

    CP

  • July 5, 2011 at 9:37 pm

    #1348720

    Not sure if this will work for all the platforms that you desire, but VisualSVN is pretty nice, and is relatively cheap to boot.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • July 6, 2011 at 6:51 am

    #1348885

    Great, I'll check this out.

    By the way, we are using SSRS 2008 (BIDS 2008)

    Thanks!

  • July 7, 2011 at 11:25 am

    #1349891

    We've been using GIT for several months here with all of our source code, including our ssrs development projects. we save all sql objects that we create/edit as scripts. every time we need to change a sp, function, etc. we use an editor (notepad++) is our choice. make the changes there, copy/paste the code into a ssms query window to test.

    there is plenty of tutorials, docs, etc. on the web on how to use GIT, including lots of youtube videos.

    I highly recommend it.

    atfalatitkb

  • July 7, 2011 at 11:28 am

    #1349894

    I would go TFS or SVN depending on funding. Both are good IMHO.

    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

Viewing 5 posts - 1 through 4 (of 4 total)

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