August 30, 2016 at 6:27 pm
Came across something new that I need help with.
Been given a project to review several SSAS databases that were designed by someone else long ago who is no longer available. I need help confirming the latest design files and/or synicjng them to production version
I can view the dbs in SSMS. And, I believe I located the design files from Visual Studio (BIDS). When comparing the two, all the main objects match. However I noticed some members of a role in SSMS was diff than in BIDS. I assumed the designer must have made some changes dirextly in SSMS or that I wasn't looking at the real/latest design flies.
I've searched and searched for design files but decided rather then continue that (the designer wasn't clean and has stuff all-over the place), best solution was to just sync this design project to the production version .
How do I do that?
Of course I didn't want to redeploy because don't want to accidentally overwrite production version with old or wrong configuration.
August 31, 2016 at 12:06 pm
I would create a new project based on the SSAS production instance.
https://technet.microsoft.com/en-us/library/ms365361(v=sql.105).aspx
August 31, 2016 at 1:59 pm
Ah. Excellent. Makes sense. I'll try it out. Thank you!
September 12, 2016 at 12:59 pm
That did it. Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply