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

chizotz at mchsi.com chizotz at mchsi.com
Fri Feb 4 15:32:25 CST 2005


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




More information about the dba-SQLServer mailing list