Db Schema Report

Db Schema Report

Post by Marco J. Matcheft » Sat, 30 May 1998 04:00:00



I am using Oracle Enterprise Server 7.2.3 running on Solaris with Oracle
Enterprise
Manager 1.3.5 running on Windows NT.  I can not for the life of me
determine
how to print out the entire Database Schema.  Either a graphical or
textual report
would be fine.  It looks like Designer 2000 has a reverse engineering
tool that
would enable me to import the repository into Designer 2000 (which
appears to
have facililities for doing the above), but that seems like a hassle.
Any suggestions?
Thanks in advance.

marco matchefts

 
 
 

Db Schema Report

Post by Sylvain Faus » Sun, 31 May 1998 04:00:00


SQL-Programmer has an Automatic  Documentation Generator module.
It has 50++ reports to document your database and your work.

It has features such as print preview, multiple server in a single
batch, works in background...

It has a builtin PL/SQL and Transact-SQL lexer so it does syntax
highlighting (not keywork highlight, but syntax!) as well (and if you
print in colors... it does it too).

It also documents your Sybase and Microsoft SQL Server!

SQL-Programmer received the VBPJ Readers' Choice Award 1998
as the best PL/SQL and Transact-SQL Developement environment.  The
latest version available this month, SQL-Programmer 2.5 also features a
PL/SQL De* (a real one) with real PL/SQL Oracle Server side code
walking, variable watching, conditional breakpoints and all.  It was
built with Oracle!

For details, look at:
http://www.veryComputer.com/*.htm
and
http://www.veryComputer.com/

or call SFI at 819 778-5045, ext:152, fax 819 778-7943 or email to

And we support our customers!

Sylvain Faust
President
Sylvain Faust Int'l (SFI)
A Decade of Delivering SQL Solutions, 1988-1998

SFI Building
880 boul. de la Carriere, Suite 130
Hull, Quebec
Canada J8Y 6T5
Tel. 819 778-5045 ext. 804
Fax: 819 778-7943

http://www.veryComputer.com/

> -----Original Message-----

> Posted At: Friday, May 29, 1998 10:30 AM
> Posted To: server
> Conversation:      Db Schema Report
> Subject:   Db Schema Report

> I am using Oracle Enterprise Server 7.2.3 running on Solaris with
> Oracle
> Enterprise
> Manager 1.3.5 running on Windows NT.  I can not for the life of me
> determine
> how to print out the entire Database Schema.  Either a graphical or
> textual report
> would be fine.  It looks like Designer 2000 has a reverse engineering
> tool that
> would enable me to import the repository into Designer 2000 (which
> appears to
> have facililities for doing the above), but that seems like a hassle.
> Any suggestions?
> Thanks in advance.

> marco matchefts



 
 
 

1. Creating Reports without having access to DB Schema

Let me start by saying I'm reasonably good at Access and VB, but have
NO experience with SQL Server.  I just have a question to which I am
sure I know the answer, but wanted confirmation.

I have a custom SQL Server database where I work from which I am
supposed to create reports using Crystal Reports.  The catch is that
the database developer has not given me (or anyone else at the
company) permission to see the database schema.  So how do I create
the reports?  Is it possible?  (Assuming I have to do reports based on
multi-table views or something like that.)  I don't think it is, since
that's how I would do the reports in Access.  If the DBA is insistent
on not giving me access to the schema, is writing the reports
effectively not possible?

Also, how hard would it be for him to create a few views for me and
assign me read/execute access? Would that solve my problem?

thanks!

Pieter

2. DTS Wizard Confusion

3. Copy table schema and data from one DB to another DB

4. US-FL-Client Server & Sybase Opportunities

5. Loading reports into DB without using Data Workbench/Report Workbench

6. 7.2, JDBC, and case sensitive names

7. Financial reporting star schema

8. Multiple Databases with Openlink ODBC driver

9. OLTP db vs reporting db?

10. Reporting DB as copy of Transaction DB

11. SQL 7 Schema Reporting Tool

12. Create Schema Report

13. Invalid report schema question