Sql Queries Software

Dashboards

You just need to create dashboards using adhoc simple SQL queries # You don''t need a server-based solution # You want to be able to control how your dashboard looks without programming # You need to document and report on meta-data # You need to document your Database Schema # You need to document ERP and CRM setups # You need real-time analysis # Your users need to interact with your reports and dashboards # You need a common tool for. This business software is categorized under business databases, tools.

MS SQL Code Factory

MSSQL Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs.

pgISQL (Interactive SQL for PostgreSQL)

Interactive SQL for PostgreSQL is a powerfull database utility. It allows: Build SQL queries using SQL Editor with SQL syntax highlighting and SQL Query History features; Build SQL queries using Visual QueryBuilder; Automate routine tasks using ISQL for PostgreSQL in command line mode; Export resultset in various data formats (HTML, RTF, XML etc.); SQL query errors highlighting.

Firebird Code Factory

This office software allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs.

Oracle Code Factory

This office software allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view/edit BLOBs.

Quick Query

This business software is a Plug-In for Microsoft Access. It provides a context sensitive, simple way to perform SQL queries on the fly, without creating or saving a query using the standard Query Designer. You can also create queries too complex for the Query Designer. Keywords, restricted words and symbols, brackets and functions are all highlighted for easy identification. Open multiple windows open at once, so many queries can be worked on concurrently.

# 1 PostgreSQL Manager - Navicat PostgreSQL Client (support Access to PostgreSQL)

Navicat is an intuitive GUI tool for PostgreSQL. It lets you create, browse databases and run SQL queries in an easier way. Advanced features include visual query builder, report builder, backup/ restore, batch job scheduling, remote connecting, and the ability to easily migrate data to/from Excel, Access and other data formats. It also provides a SQL Console and supports Data Synchronization. The latest version supports HTTP connection.

StelsXML - fast XML JDBC driver

StelsXML is a JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on XML files. With StelsXML JDBC driver, you can easily access data contained in XML documents using the standard SQL syntax and XPath expressions. The driver is completely platform-independent.

Navicat for Oracle (Windows) - Oracle Database administration

Navicat Oracle tool is an intuitive GUI tool lets you create, edit databases, run SQL queries and connect to remote Oracle in an easier way. Also, Navicat provides a number of tools allowing to perform all the necessary database operations such as creating, editing, and duplicating database objects. It also offers a well-described wizard system that simplifies your database development tasks. It supports Oracle 9i and later.

PostgreSQL Code Factory

This office and business application allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view/edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view/edit BLOBs.

Odbc 4 All

Allows any application, including DOS, to easily run SQL queries using any ODBC data source, (Access, MySql, Oracle, Informix, ...) redirecting the output to the screen, an ascii file / table or a DBF table. Can be used in standalone mode and/or inside a 3rd party application, with or without user intervention. This utilities software is categorized under developmentutilities.

Database Assistant

Manipulate data from a variety of database formats including Oracle, SQL Server, Informix, MS Access, and Sybase et al with the Markosoft Database Assistant. Just select any of your pre-configured ODBC system data sources, enter a database password if applicable, and then select any table in the database for viewing and editing. Many features such as free-form SQL queries and a query generator have been included. This shareware is listed under databases, data access, database access tools category.

# 1 MySQL Gui Admin Tool - Navicat (support Access to MySQL)

Navicat is an intuitive database management tool lets you create, browse databases and run SQL queries in an easier way. Advanced features include visual query builder, report builder, backups/ restore, batch job scheduling capabilities, remote connecting, and the ability to easily import and export data to/from Excel, Access and other data formats. Latest version adds a built-in SSH tunnel, SQL Console, View Builder and supports Data/ Structure Synchronization.

#1 MySQL GUI - Navicat MySQL administrator Manager (supports Access to MySQL conversion)

Navicat is an intuitive GUI tool lets you create, browse databases and run SQL queries in an easier way. Advanced features include visual query builder, report builder, backups/ restore, batch job scheduling, remote connecting, and the ability to easily migrate data to/from Excel, Access and other data formats. Other features include a SQL Console, View Builder and Data Synchronization. The latest version supports Code Completion, Form View and e

Active Query Builder Delphi VCL Edition

Active Query Builder is a Delphi and C++ Builder visual query building component to make complex SQL queries with unions and sub-queries easily. Its user-friendly interface and unique query research capabilities provide optimized results and is sure to increase the number of potential users of your product. Active Query Builder is a true two-way query builder; a perfect choice for both SQL beginners and experienced query writers.

MSISQL (ISQL for Microsoft SQL)

MSISQL (Interactive SQL for MSSQL) is a database administration solution for managing Microsoft SQL databases. It allows to build SQL queries using SQL Editor with SQL syntax highlighting and SQL Query History features; build SQL queries using Visual QueryBuilder; automate routine tasks using ISQL for MySQL in command line mode; export resultset in various data formats (HTML, RTF, XML etc.); SQL query errors highlighting.

Navicat MySQL administrator Manager for Linux (Freeware also available)

Navicat for Linux is an intuitive GUI tool lets you create, browse databases, run SQL queries and connect to remote MySQL in an easier way. It includes query builder, report builder, backups/ restore, batch job scheduling, and the ability to convert data to/ from MySQL. Other features include View Builder and Data Synchronization. The latest version supports Code Completion, Form View and email Notification.

Regular Expressions for MS SQL server

The Regular Expressions for MS SQL Server offer an extremely powerful way to search, replace, format and extract text data inside a string using sophisticated search criteria. For example, you can search for whole words, or find a match with some pattern (e-mails, phone numbers, postal codes, etc.), and can quickly locate, count and extract all the occurrences from the searched string. This shareware is listed under database programming, database servers, database utilities, programming databases category.

Database Tour Pro

Cross-database tool with report builder. It allows viewing, editing, and printing data, building SQL queries, building reports, control transactions, configuring BDE aliases, sorting and filtering data, viewing structure, searching and replacing text, importing and exporting data (with format converting), special functions to work with MEMO, graphic, numeric, string fields. Includes command line support.

Database Tour

Universal database tool with report builder. Main features are: Viewing / editing / printing data; building SQL-queries; transactions; configuring BDE aliases, sorting and filtering data; viewing structure; reindexing; searching/replacing text; importing/exporting data (with format converting); special functions to work with MEMO, graphic, numeric, string fields. Full help.

UnityJDBC

The UnityJDBC driver can integrate and query any number of JDBC-accessible data sources (including Oracle, SQL Server, MySQL, and Postgres) in a single SQL query. UnityJDBC contains a built-in database engine and optimizer that can be used separately from the integration system. It also contains a new, faster join algorithm and syntax for matching/merging data beyond simple joins. It runs on any Java-enabled platform.

BaseNow

This software is a database front-end application that provides a powerful tree-style user interface for all your databases. It looks like Microsoft Access and it allows you to work with data just like in Excel spreadsheets. BaseNow has a tree-style display of all database objects and enables you to use SQL for data management. It works with all database formats and includes deduplication, data validation, and import/export tools.

PHP Lightning Portal (PLP)

PLP is an easy-to-use program that will help you manage your portal website. Some common areas of PLP usage: realty management, auto management, job management, downloads management, listings management, image galleries, etc. Payed membership is supported.

#1 Postgresql GUI PG Lightning Admin

PG Lightning Admin is a powerful GUI administration program for Postgresql 7.4.x and greater. It includes many advanced features such as a tabbed based MDI system, tabbed Enterprise Manager and more. Other features include a advanced function editor, SQL edtior and view editor. All the editors also code completion and function param hints.

CompareData

This development tool is a native Windows cross-dbms application that allows you to visually compare and synchronize data between two SQL databases using ODBC drivers. You can retrieve all/some data for a table/view from two databases and compare the data visually to see differences highlighted on the screen. You can also compare the data of two sql queries

SwisSQL - Sybase to Oracle Migration Tool

SwisSQL - Sybase to Oracle Edition is an automated migration tool to convert stored procedures implemented in Sybase ASE (Adaptive Server Enterprise) Transact SQL into equivalent PL/ SQL code. It automates more than 80% of the Sybase Transact SQL code conversion into Oracle PL/SQL with very minimal manual intervention.

Superior SQL Builder

The first tool to visually build complete SQL scripts - other query tools only build single SQL queries. Introduce massive time savings and reduce debugging, syntax and logic errors. Easy to use. Build complex SQL scripts without typing any SQL. Incredibly versatile, flexible and extendible - users have complete control over the SQL that is generated. Suitable for DBAs and developers of any expertise. Supports Oracle, SQL Server, MySQL, Access. This commercial is listed under database, sql, developer, development tools category.

myphpbooks

This script is a real world application that shows how to use MySQL with PHP. You can learn from the step by step commented php source code how to build a php program that uses MySQL to keep a database of your books. Program functions implemented include, saving a new record, listing of records for user selection, selection of a record and displaying its details, updating a record, deleting a record and searching for records.

EMCO EventLog Audit Professional

This tool is a tool for scanning, storing, and manipulating event log data on a LAN. It stores the event log data from all machines on a LAN to a powerful Microsoft SQL Server database where you can search for any details such as Event ID, Type, Category, Source, User SID, string from the event Message, and Time period, by applying your SQL Queries.

Ariacom Business Reports

Easy-to-use database reporting and multi-dimensional analysis tool with dynamic SQL generation. -Native line, bar, point and pie charts -Integrated security management limiting user access -Fully multilingual design (currently in English, French, German, Spanish) -Report results in various formats (html, csv, txt, xml with conversion to pdf) -Output to various devices (file, printer, fax, email)

AMS Enterprise

This internet tool is a powerful system for running mass e-mail and targeted advertisement campaigns. Your business will be more successful with a tool that completely, from "A" to "Z", resolves all issues related to e-mail marketing. With AMS Enterprise, you can easily create a mailing list, compose a proposal message, quickly send out personalized mail, and instantly evaluate the efficiency of the advertisement campaign you have just started.

e-Zvit

"e-Zvit" is an Open Source system for analizing of reports. Any tall structure of reporting organizations can use "e-Zvit" for working with blanks made in MS Excel. The system processes reporting blanks of free forms receiving on-line, by e-mail or uploading as an Excel file. Allows to create the database of reports,common for a few organizations, departments etc.

dataPro

This development tool is an advanced visual cross-platform database management, development and conversion tool. Transfer data between databases, run SQL queries, view data and export result of the query to the Excel file, text file, xml file or SQL script. Import Excel Spreadsheets and text files to the database. dataPro supports schema conversion and data copying beetween MySql, MS Access, SqlServer, Oracle and Sqlite. dataPro is licensed as commercial and filed in business databases, tools section.

GiPo@DB_Utilities

These utilities provide an easy way to work with OLEDB-compatible databases and data sources (Microsoft SQL Server 7/2000, Oracle DBMS, Informix, DB2, mySQL, Microsoft Access, dBase, Paradox, FoxPro, Visual FoxPro and many others). The GiPo@DB_Utilities contains the following components: GiPo@DB_Explorer, GiPo@DB_Console.

FlexiMIS

This software compliments the power of SQL and Excel with its own power. The report you get is a fully-formated, multi-sheet, interlinked file that can contain formula, functions, graphs, pivot tables, etc. FlexiMIS also adds headers, footers, subtotals and percentages. GUI for building SQL and formatting the reports is intuitive. The Multi-Report Mail feature enables you to create multiple report files and mail them to respective recipients.

SQLyog MySQL GUI

Import data from ODBC datasource, synchronize your database. Execute queries for updation of result. Copy databases between hosts. Generate Schema for your database. Manage Foreign Relationships and all options fully InnoDB compliant. Reorder columns.