Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Recommendations on Project ReUse Expand / Collapse
Author
Message
Posted Wednesday, June 4, 2014 3:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 6:43 AM
Points: 2, Visits: 32
Hopefully I have this in the right forum. I'm asking this as a newcomer so forgive me if I say anything completely stupid.

We have a situation where we have a project for a particular customer and everything is working perfectly fine.

We now have a new customer who requires exactly the same thing, Facts and Dimensions are all the same, even the MDX queries are the same. The only thing which differs is the content of the source data that will feed the cube (i.e. they'll have country, date, transactions etc in exactly the same format as the other company)

So from my newbie perspective is to "re-use" the working project and then modify to be populated from the new data source.

What I'm not sure is how simple this is to achieve and what process to follow. Is it as easy as copying the working sln project and renaming it. Then opening and modifying it for the new company. Or is that a roadway to hell because I'm missing something an experienced developer would already know.

Can anyone point me on the right track?
Post #1577250
Posted Wednesday, June 4, 2014 4:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 13,289, Visits: 11,074
Copy pasting the solution will probably be enough.
If it is only the data that changes, it is pretty similar to deploying a solution from the test server to the production server.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1577252
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse