Project Description
SQL Analyzer is a utility application for developers working with SQL Server. It is a stand-alone windows application that can be used to connect to a SQL Server and analyze various database objects in the server.

Functional Features List
  • Connects to different versions of SQL Server like 7.0, 2000, 2005, etc. and different editions like Express, Standard, Enterprise, etc.
  • Once connected, lists out different database objects like Tables, Views, Stored Procedures and User Defined Functions in different panes enabling a quicker search and with following additional features:
    • Tables
      • Lists column properties (name, type, length, nullable, identity, default value, etc.)
      • Marks Primary Keys, Unique Keys, Foreign Keys
      • Lists data in a grid where it can be sorted by columns
      • Lists Referring and Referred tables
      • Lists triggers and other dependent objects
      • Generates SQL scripts for Insert, Update, Delete, Select and Create
      • Exports data in the table as Insert SQL statements

sqlanalyzer.gif
  • Views
    • Displays the data in a grid where it can be sorted by columns
    • Displays the content text of the view
  • Stored Procedures
    • Displays the parameters and its properties
    • Displays the content text of the stored procedure
    • Generates VB and SQL codes to execute a stored procedure
  • User Defined Functions
    • Displays the parameters and its properties
    • Displays the content text of the User Defined Functions
  • Provides a basic query window for execution of SQL statements.
  • Provides Search inside db objects. This feature can be used to search for a text (like table name or an author name) that appears inside a stored procedure, view or user defined functions.
  • Generates Excel reports of database objects with details of table properties.
  • Easy backup and restore options
  • Compares database objects with objects in another database.

Limitations
The tool was developed in VB 6.0, targeting SQL Server 2000 and on Windows 2000 Professional. A thorough testing on other versions is not done, though it appears working fine on other versions of SQL Server and Windows. Minor errors are expected.

Last edited Jan 9, 2009 at 12:14 PM by sameerct, version 7