Tip #1153: When Upgrading, Consider the Whole Ecosystem

It is that time of year when people turn their thoughts to upgrading; the October 18 release has been announced and for those on Dynamics 365 Online v8, the clock has started. I was recently with a client who had a pretty typical setup. They had Dynamics 365 Online, NAV 2016, and an online shopping […]

Tip #943: Upgrading development environment to Dynamics 365 On-premises

Dont panic and carry a towel poster

Today’s contribution is “an old school on-prem tip” from Brian Illand. Despite the marketing hype around Dynamics 365 being a whole new product, remember that it is a ‘minor’ upgrade from Dynamics 2016 to Dynamics 365 On-Premise. Dynamics 2016 is v8.0/8.1 and Dynamics 365 is Version 8.2. So, ‘theoretically’, there is a lower than usual […]

Tip #766: Drop your full text index the supported way

As reported in the Dynamics forum, there are known issues with upgrading CRM On Premises to CRM 2016 SP1 if you have full-text indexing enabled. You will get the following error: System.Data.SqlClient.SqlException: Cannot drop index ‘cndx_PrimaryKey_OpportunityProduct’ because it enforces the full-text key for table or indexed view ‘OpportunityProductBase’. Various posts include SQL scripts to remove […]