CRM 2011 – Upgrading CRM 3 to CRM 2011

Recently someone asked this blog if I had an information on upgrading CRM 3 to CRM 2011.

This is one of those scenarios where a small piece of knowledge gained from passing a CRM certification came into my mind.  For one of the CRM exams (I’m guessing the CRM 4 installation exam) you have to learn that with CRM you cannot skill versions when upgrading and you have to upgrade one step at a time.

So if you are upgrading CRM 3 to CRM 2011 you would first have to upgrade to CRM 4 and then upgrade to CRM 2011.

I found a couple of useful forum with some good advice on resources for upgrading to CRM 2011 from CRM 3, it also made me think how useful the forums are.

This forum post was particularly useful, although it does concentrate on upgrading CRM 3 to CRM 2011 online it still covers a lot of the steps you will go through.

The first thing you should read if you are upgrading to CRM 2011 is the implementation guide which you can find here

I think the most important thing you need to consider is how many customermizations you have because these are going to add to the complexity of the upgrade and will need a lot testing.

The forum suggests using Scribe (which although I haven’t used I have heard very good things about) which will save you a lot of time.

I also found some great articles on upgrading from CRM 3 to CRM 4, which is what you are going to have to do first before you then upgrade from CRM 4 to CRM 2011, here is a video about importing an organisation into CRM 2011 from CRM 4 but first you need to read the article below

One of the problems discussed in the forum seems to discuss is getting the notes out from CRM 3 .

The quote below is taken from the forum

Here is a sql query that you can drop into SLQ Management Studio that will pull the notes related to Cases as well as the related Case #.  You’ll want to save the data off to a csv file for importing and ensure your Header Row matches exactly the Display label of each field so that the import can easily map the fields.

You can add any additional fields as needed.  I tried to grab most of the ones that I thought were relevant.

select n.subject as ‘subject’, n.notetext as ‘notetext’, n.filename as ‘filename’,
n.annotationid as ‘annotationid’, n.isdocumentname as ‘isdocumentname’,
n.owneridname as ‘owneridname’, i.ticketnumber as ‘i.ticketnumber’ from FilteredAnnotation as n
join FilteredIncident as i on (n.objectid  =  i.incidentid and (i.ticketnumber is not null)) order by n.subject asc, n.annotationid asc

I didn’t test this all the way through so let me know if you run into any issues. You may need to remove annotationid from the query as CRM will think you want to update Notes rather than import new Notes


The forum also discussed this method

For each entity that you want to migrate data from, open up a view. Then click Advanced Find. The current view will be loaded into Advanced Find and you can select which records to migrate (by applying criteria) and which columns to export (by using Edit Columns feature).

Note that there are some big limitations with this approach:

  • You’l have to import the records in sequence. For example, you need to import opportunities after importing accounts and contacts. It’s worth spending a few minutes thinking about the sequence to ensure all ‘parent’ records are imported before any dependent ‘child’ records.
  • You won’t be able to migrate any attached files — these cannot be exported to Excel.

The new CRM Online import wizard is another big improvement over similar features in CRM 3.0 and 4.0, but there are few blog resources available to help if you run into any issues.




4 thoughts on “CRM 2011 – Upgrading CRM 3 to CRM 2011

  1. Jonathan July 15, 2011 / 8:43 am


    We are currently in the process of upgrading to CRM on premesis from CRM 4.0. However in our installation of CRM 4.0 we still are making use of callouts, a hangover of the upgrade from CRM 3.0 Now ive read in many places that callouts are not supported in CRM 2011. And that CRM 2011 is only backward compatible up to CRM 4.0.

    I have been unable to find a Microsoft resource confirming this, do you perhaps have a link to such a resource?

    Additionally do you know of a list of known upgrade compatability issues for upgrading to CRM 2011?

    Thanks very much for your help!



    • Hosk July 18, 2011 / 9:24 pm

      I don’t think Call outs are officially supported. Microsoft only usually supports functionality form the last release.

      In CRM 2011 it supports the javascript using Crmform but this won’t be supported in the next release.

      It will support plugins created using CRM 4 code but these probably won’t be supported in the next release.

      I don’t know if there is a list of issues, my advice would be to try and upgrade it and then see what doesn’t work. You would have to do this anyway because you don’t know what is going to break.

      Sorry I could’t be of more help to you.

      good luck


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s