Dynamics CRM: Data Migration with SSIS (Let’s put it all to test)

By | March 29, 2017

You can test SSIS components in many different ways – you can test performance, usability, user interface, advanced functionality, and so on. Some of those tests will depend on what exactly you are trying to achieve. Before we continue, let me clarify the goal of this particular testing exercise.

As you may recall, I mentioned that I used to work with KingswaySoft components on a number of Dynamics data migration projects, so I am not, really, trying to test whether KingswaySoft is up for the task because I know it is. However, I have not worked with CozyRoc up until now, yet it seems it should be able to provide more or less the same kind of functionality.

Therefore, here is what I have done:

I have also created an SSIS package which is supposed to do the following:

  • Copy data from the local table to Dynamics using “create” operation with batch processing
  • Load generated Dynamics guids back into the local table
  • Send the same data back to Dynamics using “upsert” operation with batch processing
  • Finally, the same package will delete all test data from Dynamics

So, it’s all been pre-set, and, as it turns out, it’s all working perfectly with either of the connectivity packs.

I won’t really make a recording of the test – you will find all the test setup instructions below in case you wanted to try it yourself.

However, I still wanted to show you how easy it is to replace one set of components with another set of components in the video below, so have a look:

If you wanted to try the same yourself, you will find most of the test setup instructions here.

It’s really up to you how to interpret all this, but, I think, there are at least a few takeaways:

  • KingswaySoft components and CozyRoc components are almost replaceable. Notice how it only took me about 5-6 minutes to convert a package that was using KingswaySoft components to a package that was using CozyRoc components. Sure it was not such a complicated package, but still
  • As with everything else, KingswaySoft is paying more attention to the visuals. There are dynamic hints, there are nice icons, etc
  • As far as Dynamics connectivity is concerned, it seems both products are offering about the same functionality

In the end of the day, choosing one product over another might be all about your personal preferences. Although, considering the licensing and pricing models of those two.. CozyRoc might just have the edge if your budget is tight.

This was the last post in the series. I’m hoping you have enjoyed the reading, and I will definitely appreciate your comments/feedback. So, get in touch and let me know what you think!

2 thoughts on “Dynamics CRM: Data Migration with SSIS (Let’s put it all to test)