RE: Rever Engineer relationships from SQL DB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 The Relationship information should be retrieved into the model at the same time as the tables, assuming that you included all of the tables in a relationship within one Reverse Engineer action.
\par
\par For instance, if I have tables A, B, C and D, and there is a relationship between B and D, I should include B and D together (along with other desired tables) in the list of items that I reverse engineer together.
\par
\par If instead, I reverse engineer once, and retrieve only A and B, then later I retrieve C and D, then I have no relationship, because B and D are not bring brought into the model together.
\par
\par Another thing that you should know is that these must be true relationships in the SQL database. Triggers and other forms of code / stored procedures which perform database maintenance to enforce integrity rules are NOT relationships, and will not be presented as such.
\par
\par I hope that helps!
\par
\par
\par Barb Way
\par Product Support - Visio
\par Microsoft Corporation
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par }