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