version control for SSRS report files
Hi Experts,
I would like to know if anyone has any opensource software or any good software they can recommend that i can use for version control. I have created a number of reports on different servers and then forgotten which was the last report I sent to client. I normally use visual studio but I only need to save the report file. But I have noticed that emailing reports without zipping can corrupt reports so need to make sure that what ever version control system i use it is not going to corrupt the report in anyway.
Many thanks C
I would like to know if anyone has any opensource software or any good software they can recommend that i can use for version control. I have created a number of reports on different servers and then forgotten which was the last report I sent to client. I normally use visual studio but I only need to save the report file. But I have noticed that emailing reports without zipping can corrupt reports so need to make sure that what ever version control system i use it is not going to corrupt the report in anyway.
Many thanks C
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Since each report is stored in a separate XML-based RDL file, Reporting Services projects play well with version control.
You can also you TFS for version control
You can create your ssrs project and MAP it with TFS which will keep track of each of your checked in changes in the Report
You can create your ssrs project and MAP it with TFS which will keep track of each of your checked in changes in the Report
>then forgotten which was the last report I sent to client.
Does the client always have the most current version?
If your company does continuous work on SSRS reports after sending to a client, then the source control system may not always have info on what the client has, so you'll have to track it the old fashioned way on a spreadsheet somewhere.
OR write the version number real small on the report so it's not abundantly noticeable, say the report footer in small-ish font, so it's easily identifiable.
Does the client always have the most current version?
If your company does continuous work on SSRS reports after sending to a client, then the source control system may not always have info on what the client has, so you'll have to track it the old fashioned way on a spreadsheet somewhere.
OR write the version number real small on the report so it's not abundantly noticeable, say the report footer in small-ish font, so it's easily identifiable.
ASKER
Thank you, Deepak, GIT seems like the best fit for keeping track of my reports and also for our other applications not using Microsoft technology.