July 5, 2011 at 3:43 pm
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 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. Also, I found that BIDS 2008 has Source Control "Plug-Ins" that may be a solution. Although I am completely new to this and the plug-in might be the actual tool, i.e Team Foundation Server (for example).
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 4:57 pm
Hi,
I'm working on a team using SSRS 2008 R2 and we have Tortoise SVN, but the problem we are having is multiple developers having their own version of the project file/solution, it can't seem to cope with merging the file together.
We have had to revert to one person each week updating the main project file/solution after all amendments have been committed, and then everyone updating their personal directory back from the repository. This seems to be working quite well at the moment, so long as they all commit their work.
I'd be interested in hearing what you decide on so I can try it out and suggest it to my project manager.
Thanks
July 6, 2011 at 11:46 am
I have used all three you mentioned and IMHO TFS is the best fit for you mainly because of the development environment integration it offers into BIDS and the testing coverage they probably had to do for making sure people could merge their own code artifacts, e.g. from SSRS. I am not sure what they have developed for the PL/SQL community but they have reached outside their comfort zone in some areas. For example they offer an Eclipse plug-in.
SSRS artifacts would be treated as text files in terms of merging in TFS Source Control. The branching and merging in TFSSC could have been characterized as "spotty" at times in TFS 2005 but it became quite solid in TFS 2008...I haven't used TFS 2010 extensively yet although some of the marketing presentations I have seen on the Branch Visualizer look awesome.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 6, 2011 at 12:05 pm
I have used all three mentioned. TFS works very well for what you are looking to do. With SVN, we had good success using mercurial. Branching and merging seemed easier with that flavor of SVN. But as OPC.Three said, TFS is built with the integration already in place making it a better fit.
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
July 6, 2011 at 12:17 pm
Thank you all for your input!
We are going to move forward with TFS 2008 with the Team Explorer 2008 for accessing TFS. We plan to integrate this into BIDS 2008 (VS 2008) for SSRS 2008 purposes.
As for testing, I may need some help..
I am using a Windows Server 2008 Virtual Machine. I believe the IIS is already present in the VM, but I am not sure about BIDS... do I need to install SQL Server 2008 along with BIDS 2008 onto the VM? or can I set up the TFS 2008 on the VM and access it from BIDS 2008 on my machine?
Or if anyone else has any suggestions on how to approach testing TFS 2008, I would appreciate hearing it.
Thanks!
July 6, 2011 at 12:19 pm
You can setup TFS on the VM and then access TFS through Visual Studio / BIDS on your machine.
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
July 6, 2011 at 12:21 pm
Thanks for the quick response!
I'll let you guys know how it goes!
July 6, 2011 at 12:27 pm
Cool. Thanks for posting back. It's nice to hear the direction after the questions are answered and a decision is made 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply