Compartilhar via

MS CRM V1.2 Logical Model on MSDN

  • Artigo

Quite a few people have asked for the database schema for CRM 1.x. Well, we were a little hesitant about handing it out for a few reasons. One, we really don't think you should be partying on the database directly. Two, there was no reasonable delivery mechanism for doing so. Well, this morning our UE team posted the logical model on MSDN. This is a big Visio diagram that shows all the entities, the definitions (no attributes), and all the relationships, both logical and physical. Thanks to the CRM UE team for putting this together.

A little trivia - this model was generated from the metadata using VBA and then hand-tweaked to fix some of the layout issues. Just thought that was an interesting take-away.

Comments

  • Anonymous
    March 15, 2005
    Which Version of Visio do I need to be able to open the file?

    I tried it with the german version that ships with VS.NET 2003 Enterprise Architect (i.e. Visio XP/2002) and I only get an error message:

    "This file cannot be opened, because it has been created with a newer or unknown version of Visio". (My translation from the german error message)

    Do I need Visio 2003 to open the file? And if so, why?
  • Anonymous
    March 15, 2005
    Arne, I've sent mail over to our UE team to figure out which version this is. I'm assuming that it's 2033 because that was the version I was running when I created the original macro for them. When I know something I'll post it.
  • Anonymous
    March 16, 2005
    Dear Mike,

    Sonomapartners presented a Visio 2002 and Adobe PDF-Version a few minutes ago:

    http://www.sonomapartners.com/microsoft-crm-database-diagram.aspx

    so my problem is solved.

    Thanks
  • Anonymous
    March 17, 2005
    I had no problem opening the visio file. I'm running Visio 2003 sp1 (Swedish). Only had a security waring about macros.
  • Anonymous
    March 17, 2005
    Great job on this Visio.
  • Anonymous
    March 24, 2005
    Use a Visio Viewer if you have version issues that you can download from -

    http://www.microsoft.com/downloads/details.aspx?FamilyID=3fb3bd5c-fed1-46cf-bd53-da23635ab2df&displaylang=en