[dba-SQLServer] Partially OT: Need to Reverse Engineer

Hello Marty,

Well, all righty then. Thank you, very much.

Ron


Friday, February 4, 2005, 6:23:35 PM, you wrote:

M> Here are a couple of reverse engineering tools for data modeling
M> They are in $200 range
M> CaseStudio
M> http://www.casestudio.com/enu/reverse.aspx
M> Enterprise Architect
M> Data Modeling, Forward Database Engineering to DDL and Reverse Database
M> Engineering from ODBC
M> http://www.sparxsystems.com.au/

M> chizotz at mchsi.com wrote:

>>I need a program that is free or extremely cheap that can reverse engineer
>>both SQL Server and Oracle databases. I have and use Visio 2003, which does an
>>OK, but not great, job for what I need, but the SQL for views is truncated in
>>many cases, apparently an arbitrary limit of some kind, and I need to see the
>>full and often lengthy SQL behind views on databases that I did not create. In
>>the case of Oracle, I do not have any of the Oracle tools available to me and
>>can only connect to the database using the MS tools (EM, QA, .NET). I use
>>Enterprise Manager to test queries against the Oracle database and am
>>developing methods similar to data warehousing techniques to bring some of the
>>data over to SQL Server (where I have full unrestricted access).
>>
>>Failing a free or really cheap program to do this, can anyone point me in the
>>right direction to how to write one in .NET?