November 8, 2011 at 9:41 am
Are there any pros or cons to putting all projects (SSAS, SSIS, SSRS) in one solution? There are about 30 projects.
November 8, 2011 at 9:54 am
Why are you asking?
November 8, 2011 at 10:01 am
Another person in the department insists that all the projects (SSAS, SSIS, SSRS) should be stored in one solution. The projects don't neccesarily relate to each other, they are just all on the same server. Just wanted to know if anyone has any experience with that and are there any pros or cons.
November 8, 2011 at 10:08 am
Terrie (11/8/2011)
Are there any pros or cons to putting all projects (SSAS, SSIS, SSRS) in one solution? There are about 30 projects.
I guess the only possible con is that it may take a long time to load in BIDS...if you have 30 projects. Breaking it up into smaller pieces may make it more manageable.
I usually like putting all of it in one solution, as it makes it easier to work on the different projects without opening another solution. But then again, I don't have 30 projects in my solutions...
November 8, 2011 at 10:09 am
The only point I can bring on the table is that it's really annoying to load all those projects on startup. I have a "small" solutions with 200 reports over 10-15 solutions and it takes 1 minute to open Bids.
What are your pros and cons? Maybe it'll give us more ideas.
November 8, 2011 at 10:14 am
Multiple people are working on the different projects and switching back and forth between production and deployment. It looks like an all eggs in one basket to me.
November 8, 2011 at 10:15 am
It looks like no source & change management control to me :-).
That'd be the real issue!
November 8, 2011 at 10:15 am
If the projects relate to each other then i think its good to put them in the same solution, for example SSIS/SSAS/SSRS projects all relating to one BI solution.
but for projects that are in no way related then I see little point in combining them.
November 8, 2011 at 10:47 am
Typically, the anchor and common denominator of the solution that contains these types of projects is the database project. It was not mentioned but I assume it would be there.
November 11, 2011 at 1:00 pm
"the projects relate to each other then i think its good to put them in the same solution, for example SSIS/SSAS/SSRS projects all relating to one BI solution.
but for projects that are in no way related then I see little point in combining them. "
what he said.
I, personally, would push back to "the insistor" and have them justify why everything *should* be in one solution. more cons than pros, imo.
I only have a handful of projects, all related, and BIDS still gets bogged down. I simply cannot have my dev environment slower than it already is.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply