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

Hi Ron:

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

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

HTH
Jim

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

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