SQL Analyzer

Status: Archived | Type: Windows Application | Year: 2001-2006 | Techs: Visual Basic 6.0

Introduction

SQL Analyzer is an open-source utility tool for developers working with SQL Server. It is a stand-alone windows application that can be used to connect to an SQL Server instance and analyze various database objects in the server. Features include fast searching, code generation, database comparison, reporting and more.

Features

• Connects to all versions of SQL Server (7, 2000, 2005, Express, etc.)
• 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, etc.)
    • 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 a 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.
• Compare two databases.

Screenshots

Download

Download Link | Download full source code from www.planet-source-code.com | Download full source code from CodePlex

The zip file contains the executable file and dependent libraries. You will have to manually register them on a 32 bit Windows computer before launching the application.

SQLAnalyzer.NET

Status: Archived | Type: Windows Application | Year: 2005-2015 | Techs: Windows Forms/VB.NET/C#.NET 2.0

Later on I re-wrote the SQL Analyzer using .NET and continued using it at my work places for handling SQL Server database objects.