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

Holy cats Jim, that may be my answer! My boss can hardly argue with
'free'!

Thank you!

Ron


Friday, February 4, 2005, 8:33:14 PM, you wrote:

JL> Hi Ron:

JL> There is a nice open-source application from www.fabforce.net called
JL> DBDesigner:
JL> http://www.fabforce.net/downloadfile.php?iddownloadfile=1

JL> Might be just what you need. It works with MySQL, SQLite, Oracle, MSSQL and
JL> any ODBC connectable database.

JL> HTH
JL> Jim

JL> -----Original Message-----
JL> From: dba-sqlserver-bounces at databaseadvisors.com
JL> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
JL> chizotz at mchsi.com
JL> Sent: Friday, February 04, 2005 1:32 PM
JL> To: dba-sqlserver at databaseadvisors.com
JL> Subject: [dba-SQLServer] Partially OT: Need to Reverse Engineer

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

JL> Failing a free or really cheap program to do this, can anyone point me in
JL> the 
JL> right direction to how to write one in .NET?