Microsoft Dynamics CRM for Small Mid-Size Business Blog

Microsoft CRM How To Articles, Project Stories, Training Books, Programming Sample Codes, Expert Tips, Best Practices, Tutorials, Whitepapers, News, Overviews, etc.

My Photo
Name:
Location: San Francisco, California, United States

Sunday, January 16, 2005

A Must Have: Scribe Software - Data Migration Tool for Microsoft CRM

So, it is the 11th hour on a super big and high visibility Microsoft CRM project and guess what - the client decided they need to migrate a “just identified” legacy system's data over to their new Microsoft CRM (Please note that this is NOT one of our Workopia's clients, but someone else's project that we are lending a hand to help - name will be undisclosed to protect the innocent!) And on top of that - their primary Microsoft CRM consultant on the project is no longer with the company.... You also probably asking how come they "didn't know" about another legacy system earlier??? Oh well...

So, you get the picture - 100% reaction mode!!! No easy way out of this one either, the timeline is FIXED!!! Now, I know the more experienced consultants out there know that this sort of situation happens all the time in our industry (not on my watch!). But, no biggie right! "Just go in and fix it" and if it was easy, they wouldn't need folks like us...

Long story short, the whole team pulled through. I have to say - that the folks I'd worked with on this project exemplified some of the top-notch, get things resolved characters I'd respect. No BSing around, get straight to the point, make the needed decisions and get on with it!

Ok, reading up to this point, you must be asking what the heck does this have to do with Scribe Software??? Well, speaking from my 12+ years of experience in this field, data migration at the 11th hour requires a few "must" haves without one checking oneself into a “mental” motel afterwards:

1. Someone that really knows how the "whole" data migration process works, been in the trenches and SURVIVED so that the team feels confident during the "dark, dark hours" of data migration journey

2. A tool that is quick and easy to work with - so your team doesn't spend time "fighting the tool" and guess which tool I'm talking about and recommend - yup - Scribe Software!!! And make sure that someone in your data migration team KNOWS and is TRAINED on how to use the tool properly.

11th hour on a project and the Scribe tool performs like a champ... I will elaborate more on this later...

3. If you have questions or needed data, your team can get'em ASAP, even fast is not good enough! No long paperwork or time barriers here - can't afford to! If they don't know what they want and can't give you access to it at the 11th hour.... then they ain't gonna get it... (and you should just walk away to avoid being abused!)

OK, so more on Scribe Migration tool - for $495, your client get to use its feature for 45 days, not bad at all! Let's face it, the cost of most data migration project is on the 80/20 rule - 80% on the people's time! So spend the money and get this tool. It is Graphical!!! Mature and Flexible.

Two things on this Microsoft CRM project that Scribe really stood out:

1. Certain field ("responsiblecontactid") in the Case (incident) object is not accessible by the out of box Data Migration Framework (DMF) tool... Oops. But Scribe could.

2. Very flexible as it allows "multiple" ways to bring data in. For example, we've tried one approach but it didn't turn out well AND we don't have much time to trouble-shoot (remember it is the 11th hour!), so we've tried another approach and it worked. This really helps because Scribe doesn't lock you down to one way, and if that way doesn't work, you have "options" - great for the 11th hour project!


Now, what about the out of box Microsoft CRM Data Migration Framework (DMF) vs. Scribe Software tool you'd ask? Here is my take on it:


1. DMF is faster than Scribe since Scribe uses 100% Microsoft CRM SDK to access and manipulate the Microsoft CRM data, how much faster? – I don't know, never benchmark it yet. So, on large data migration volume with millions and millions of records, the speed of DMF maybe of an advantage

2. DMF is not Graphical and thus require more "training", requires more SQL knowledge (not a bad thing for Complex Data Migration projects)

3. DMF is "FREE", well, included with your Microsoft CRM license anyway


So, the bottom-line - I think that if you can use Scribe for your data migration as the first tool option, USE IT, and if it doesn't work then use DMF.


Frank Lee
Workopia, Inc.

Sunday, January 09, 2005

Quick Start Guide: Microsoft CRM v1.2 on Microsoft Small Business Server 2003

Here is an excellent document (PDF format) produced by Mighty Microsoft on setting-up Microsoft CRM v1.2 on Microsoft Small Business Server 2003. Guess who contributed to this Microsoft CRM article... (credited on the last page) You guessed it -- yours truly.

Microsoft CRM v1.2 on Microsoft Small Business Server 2003 Quick Start Guide

As with any Microsoft Guide of this type, there is no direct support. However, I will try my best to respond to your posting on our Microsoft CRM Forum where I moderate.

Also here is a link to other good online Microsoft CRM Discussion Forums.


Enjoy!
Frank Lee
Workopia, Inc.

Monday, January 03, 2005

Inside MS-CRM Blog

Great link for those readers that like to dig deeper into Microsoft CRM!

Inside MS-CRM by Mike Miller.

Frank
http://www.workopia.com


How To: Adding a custom field to Microsoft CRM Contact object

This is one of the Microsoft CRM Customization How To Articles that I've written. My aim is for these articles to be very reader friendly (MSCRM beginners and up) with step by step instructions and lots of screen shots.

How To: Adding a custom field to Microsoft CRM Contact object
http://www.workopia.com/howto/AddingCustomField.htm

Enjoy and please comment!


Frank
http://www.workopia.com