worddiva
nancy.lytle at gmail.com
Fri Feb 4 15:39:11 CST 2005
You might check out apexsqldoc.exe I used it and love it for getting all the information out of a database. And its really not that expensive, under 200 and it creates a help file of the database that you can search etc, show the dependences for each item. Etc. I just wish I could get my boss to go ahead and buy it. Apex also has some other good looking items. Nancy On Fri, 04 Feb 2005 21:32:25 +0000, chizotz at mchsi.com <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 > >