Data Modelling Tool in Visual Studio 2005

Data Modelling Tool in Visual Studio 2005

• u_r_twisted

  Hi Amit,

  There are no DB modeling tools available in VS 2005 however you can connect to DB from VS and create tables etc.

  If you are looking for tool support like Erwin or PowerDesigner the closest thing Microsoft has is Visio for Enterprise Architects where you can use the Entity Relationship model (ER) and Object Role Modeling (ORM).

  Visio for Enterprise Architects is included in MSDN Premium, which is available with Visual Studio Professional and Visual Studio Team System role-based editions.

  Sandor

  
  

• merrylep

  Hi amit lohia

  I have just started working with Visio for Enterprise Architect and find that the ORM (object role modeling) is an excellent way to model your data models. I have been working with design of databases for quite some time and find this to be the most precise and - once grasped - most easy way of defining your data models. ORM models can with a few steps be converted into ER diagrams that are normalized beyond the 3rd normal form.

  Here is a good place to start: http://www.orm.net/

  Good luck - dampbarn

  
  

• pbriggs

  We are using Sparx EA to produce our diagrams and data dictionaries.

  It uses UML syntax, so you would need to be familiar with that.

  This Book cover the UML syntax.

  
  

• lizzy64

  Thanks Sandor.
  
  

• nikoo

  Hi Amit,
  In the interest of full disclosure I feel the need to tell you that I am part of the ERwin Development Team. We are currently integrating ERwin with Visual Studio for DB Professionals.
  -Sean
  
  http://www3.ca.com/press/PressRelease.aspx CID=95493
  
  
• Data Modelling Tool in Visual Studio 2005