HOME         User: Anonymous search for  in 
Login
Username:

Password:

Navigation
Registered User Functions:
  1. Register New Account
Anonymous Functions:
  1. Home
  2. Users
  3. Archives
  4. Templates
  5. Articles
  6. MyGeneration Website
  7. MyGeneration Forums
Categories
    Application Type
    1. Command Line
    2. Graphical User Interface
    3. Library
    4. Sample
    5. Web Application
    Architecture Type
    1. Client-Server
    2. Distributed Computing
    3. Multi-Tier
    4. Peer-to-peer
    Operating System
    1. Linux
    2. Win32
    Programming Language
    1. ASP
    2. ASP.Net
    3. C#
    4. C++
    5. Firebird SQL
    6. J#
    7. Java
    8. Jet SQL
    9. JScript
    10. JSP
    11. MySQL
    12. Perl
    13. PHP
    14. PL/SQL
    15. PostgreSQL
    16. SQL
    17. Transact-SQL
    18. VB.Net
    19. VBScript
    20. XSLT
    Archive: Database Report
    Author: slade52
    Created: 2/10/2008 1:34:05 PM
    Last Updated: 2/10/2008 1:34:05 PM


    This is a simple template that creates a text description of a database. It lists tables, and for each table: - the columns, - primary keys, - foreign keys (in/out), - indexes, - and stored procedures that use the table. My network configuration prevents me using tools like Red Gate to compare dev and production databases, so instead I generate this report on both and compare the reports in WinMerge. Not pretty, but it works :) The report is also useful when modifying a table because it tells use what stored procedures need to be checked as well.
    Templates (by Title)
    No matching records found.
    Files (by FileName)
    No matching records found.
    Articles (by Title)
    No matching records found.
    Related Archives (by Title)
    No matching records found.
    Messages (by Date Created)
    No matching records found.
    Copyright © 2004 MyGeneration Software. All rights reserved.
    Feedback: feedback@mygenerationsoftware.com
    Support: support@mygenerationsoftware.com