Wednesday, December 26, 2012

XRM Speed Builder for Microsoft Dynamics CRM

I've been working with CRM MVP Jamie Miley on a project to eliminate some of the tediousness of creating new entities and fields when moving to Dynamics CRM from another application. The initial release has been published has been published today on CodePlex so if you have a chance head over and give it a look.

The current functionality will read a SQL Server database and create new CRM entities and attributes based on the existing table structure. Metadata required to create the objects is pulled in and SQL Server data types are matched up with their corresponding CRM types to reduce the work needed to get things created. At the same time most everything can be overridden before being created just in case your source database isn't perfect :) Last but not least we've included the option to drop all the newly created fields on the main form to give you a head start for creating the first user interface. 

In upcoming releases we'll expand the source database types beyond SQL Server (MS Access, MySQL, Oracle, etc...) and include functionality to auto create relationships to other entities based on their foreign keys and/or allow creating relationships that aren't defined in the existing database. Any suggestions for additional functionality is always welcome.