Archive for October 29, 2014

Base and Extension base tables Merge error – Upgrade from CRM 2011 to 2013

October 29, 2014 Leave a comment

As we know till CRM 2011, CRM maintained two database tables for each Entity:

  • Base table for the out-of-the-box fields of an entity
  • Extension table for the custom fields added to an entity

With CRM 2013, Now there is just one entity table for a given entity.

So when you upgrade CRM 2011 to 2013 Organization using Deployment manager, both base & extension base tables will be merged automatically.

Refer this link on how to upgrade Organization from 2011 to 2013.

However, you might get merge error stating:

“This may exceed that the architectural limits of Microsoft SQL Server, and the merge operation will fail.”

Refer this link on how to fix the table merge error.