Welcome to MSDN Blogs Sign in | Join | Help

MS CRM V1.2 Logical Model on MSDN

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.

Published Tuesday, March 15, 2005 8:59 AM by mikemill
Filed under:

Comments

# re: MS CRM V1.2 Logical Model on MSDN

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?
Wednesday, March 16, 2005 6:17 AM by Arne Janning

# re: MS CRM V1.2 Logical Model on MSDN

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.
Wednesday, March 16, 2005 7:42 AM by Mj Miller

# re: MS CRM V1.2 Logical Model on MSDN

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
Wednesday, March 16, 2005 9:21 AM by Arne Janning

# re: MS CRM V1.2 Logical Model on MSDN

I had no problem opening the visio file. I'm running Visio 2003 sp1 (Swedish). Only had a security waring about macros.
Thursday, March 17, 2005 9:37 AM by Jonas D

# re: MS CRM V1.2 Logical Model on MSDN

Great job on this Visio.
Thursday, March 17, 2005 3:01 PM by MKatsev

# re: MS CRM V1.2 Logical Model on MSDN

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
Thursday, March 24, 2005 10:31 PM by Anon
New Comments to this post are disabled
 
Page view tracker