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

• 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.