Symptoms

Assume that you have some models that have multiple versions in SQL Server 2008 R2 Master Data Services (MDS). When you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDS or SQL Server 2014 MDS, the business rules that make references to Domain-Based Attributes (DBAs) are modified during the upgrade process, and the DBA reference is removed.

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:




If you have already upgraded to SQL Server 2012 RTM or a later version that does not include this hotfix, follow these steps to resolve this problem.

Note This fix assumes that you have the original SQL Server 2008 R2 database backup.

  1. Upgrade the SQL Server 2008 R2 MDS instance to SQL Server 2012 MDS. (Wait to run the MDS Database Upgrade Wizard until step 4.)

  2. Upgrade the SQL Server 2012 MDS instance to SQL Server 2012 SP1.

  3. Upgrade the SQL Server 2012 SP1 MDS instance to SQL Server 2012 SP1 Cumulative Update 10.

  4. Run the MDS Database Upgrade Wizard in the Master Data Services Configuration Manager.

Note If you do not have the original SQL Server 2008 R2 database backup or if you cannot afford to lose the work on the existing SQL Server 2012 database, you must add the missing DBA manually.

To verify that the hotfix works after the upgrade is complete, go to the Business Rules page to check whether any business rule that originally had DBA reference still has the DBA reference.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×