Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Assume you have 2 SSAS databases, DB1 and DB2, that are identical.

Now they branch off. Changes A and B are made to DB1 and changes C and D are made to DB2.

Is there an easy method to migrate changes A and B from DB1 to DB2 without overwriting changes C and D made in DB2?

I'm using SSAS 2005 - does this functionality improve in 2008? Third-party tools that do this?

share|improve this question
    
This exists already on SO: SS Analysis Services ( SSAS ) DB schema comparison tool?. Do you think it answers your question? –  Marian Sep 22 '11 at 9:42

1 Answer 1

You might not consider it as "easy", but I've done it a few times via the following method, which had the virtue of being easier than the alternatives of checking every setting in BIDS.

In BIDS you can create a New project and import it from your existing DB1 (and then DB2.) Now you have Solution folders/files for each DB. You can use WinDiff to compare the folders and XML files within them and sync them by hand, if you're bold enough and/or the differences are small enough. You have to use some intelligence and intuition which object IDs you may need to copy/change and which to leave alone.

If you can't get that to work, the WinDiff-generated XML differences should at least remind you and/or point you to what has been changed in BIDS and you can make changes to the DB2 project files by hand via the normal BIDS UI.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.