May 23, 2007 at 1:20 pm
We are looking into starting a data model and data dictionary of an already existing sql server database. We have stumbled upon an article talking about a set of tools that comes with sql server -- the article refers to them as 'Sql Server's DaVinci code for data modeling'. At this point, we are just researching for the proper tool to accomplish the job. If you had a choice of purchasing a data modeling tool to work in conjunction with sql server -- which tool would you buy? Are the data modeling tools that come with sql server a viable starting point?
Thanks for any comments.
May 24, 2007 at 9:50 pm
You can use them, but you should remember that it is not really a data modeling tool, but a way to build and maintain a database with a GUI tool that represents the database as a physical model. You are not building a model, but an actual database. It does not do any form of logical data modeling.
Database diagrams are a good way to represent the relationships between tables as they actually exist in the database.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply