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

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

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?
>
>Thanks,
>
>Ron
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada