[Type the abstract of the document
here. The abstract is typically a short
summary of the contents of the
document. Type the abstract of the
document here. The abstract is
typically a short summary of the
contents of the document.]
SQL Builder
[Type the document
subtitle]
IRS Project House
SQL BUILDER
SQL BUILDER is a fully functioned query builder application. It provides Oracle as
well as SQL Server Databases and user friendly interfaces for entering SQL
commands. There are lot of wizards to implement the TABLE, View, Procedures,
Functions and Triggers etc. We can use keyboard shortcuts for the execution of
queries. The queries can be stored as .sql files and that can also be open for
further execution.
• Database independent. You can create schema report for Microsoft SQL
Server database as well as for Oracle or for Interbase. The software
product supports all common database interfaces: ODBC, IDAPI, OLE DB,
or Oracle Call Interface.
• Functionality. Product allows you to include the following objects to the
report: tables (with detailed columns information), views, indexes, foreign
keys, triggers (with type and status), procedures, defaults, rules and roles.
Moreover, the program helps you to add to report DDL statements for
database objects.
• Annotations. You can make your database schema reports more friendly
by adding notes for your objects in automatic or manual mode.
• SQL editor with syntax highlighting, multilevel Undo/Redo features and
integrated searching and replacement tools. You can use macros to
automate entering frequently used fragments.
• Supports ODBC, IDAPI, OLE DB, OCI (Oracle Call Interface) data source
connection with detailed database information. Provide quick view of the
database schema and results of the query execution.
• Easy access to the file history and the history of the scripts already
executed. You can quickly switch to the required file or previously run
script with just a single mouse click.
• Convenient way to display results of the script execution. Application
supports clipboard and data export tools. The program exports data to
plain text, HTML page, XML document and Microsoft Excel spreadsheet.
You can save query results as a set of SQL statements.
Software Requirement
Operating System : Windows XP/Vista
Frame Work : Windows Frame work 2.0 or above
Web Server : IIS 6.0 or above
Reporting Tool : Crystal Reports
Hardware Requirement
Processor : Pentium III-compatible processor or faster
Processor speed : Minimum: 1.0 GHz, Recommended: 2.0
GHz
or faster
Primary memory : Min 512MB
Recommended : 2.0 GB or more
Secondary Memory(HDD) : Min 5GB or above
Peripherals : Mouse, Keyboard
VGA or higher resolution : at least 1,024×768 pixel resolution
Platform Deatls
Frond end VB.Net 2008
Back End SQl Server 2005