A Versioning system for SSRS

  • eejunk

    SSC Journeyman

    Points: 93

    Hi, found this sweet post now. Since it's dated 2 years ago, I wonder - did a better solution pop out in the meanwhile? this patch is wonderful, and we too have both the VS and ReportBuilder working (although ReportBuilder works much more in our project).

    we're looking for an easy plugin that connects our TFS SVN to our reports... anything newer and more comprehensive come out?

  • DavidKBennett

    Right there with Babe

    Points: 752

    I have seen nothing in the market that addresses this challenge, other than what was there four years ago when I originally built this system. We still use it at my work and it continues to be very useful for those occasional moments when we need to rollback to an earlier version.

    We use Git as our primary VCS, but this system runs along side it as the two really aren't compatible. I've thought of creating a PowerShell script to pull from the table created here and push it into Git, but I don't have the scripting mojo to do it without significant effort and there just hasn't been any impetus to devote the effort.

    We are more or less happy with the way things are working.

    Hope that helps,

    Dave

  • eejunk

    SSC Journeyman

    Points: 93

    thanks for the quick reply! I haven't found anything else either. I'm gonna adopt your system 🙂

    so cool that something you built long time ago still rocks the web. thumbs up, friend.

  • ptm3rck

    Newbie

    Points: 9

    Hi,
    talking about raising from the grave 😀
    First of all thank you for sharing this nice and simple solution.

    Looking at the script i was wondering why it's used "Type != 3" instead of "Type = 2", assuming of course we only want to control versions of RDL's.
    Can someone take the time to explain it to a new guy finding its way through the SSRS Ways!

    Thank you.

  • DavidKBennett

    Right there with Babe

    Points: 752

    ptm3rck - Tuesday, January 2, 2018 10:13 AM

    Hi,
    talking about raising from the grave 😀
    First of all thank you for sharing this nice and simple solution.

    Looking at the script i was wondering why it's used "Type != 3" instead of "Type = 2", assuming of course we only want to control versions of RDL's.
    Can someone take the time to explain it to a new guy finding its way through the SSRS Ways!

    Thank you.

    There is no reason you couldn't use Type=2 if RDL's are the only thing you want to track. We like to track shared datasets and datasources as well, though I have to admit I've never rolled back a datasource. And yes, we are still using the system, though with the stability of SSRS 2016, I have had much less cause to rollback because of corruption which was a more common problem in earlier versions of SSRS.

Viewing 5 posts - 46 through 50 (of 50 total)

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