Database SQL tool, which allows running the same SQL queries on multiple databases with similar structure at once. Result of query (if any) can be exported to file (TXT, CSV, DBF, XML, HTML, RTF, XLS). Connection parameters for each database are stored in the file of internal format, so if they are specified once, then there is no need to provide them again. The most important operations can be performed also via command line.

dbase dbf html rtf connection parameters export tool xml html

Firebird 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 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs.

visual query builder firebird database server csv text excel csv sql scripts

StelsCSV is a JDBC driver that allows to perform SQL queries and other JDBC operations on text files (CSV, DSV, tab-separated, fixed-length, etc). Using this driver, you can easily create a fast database consisting of plain text files. Also, the driver can be used for writing data importing programs and migration tools.

reading text files string conversion migration tools jar archives numeric string

SQLConsole creates SQL queries using drag and drop Visual Query Builder for every database (ODBC). As easy as dragging and dropping tables and joins the most complex of queries can be developed in mere minutes. Full support for correlated subqueries, totally configurable SQL functions and target mapped function drag and drop operations. SQL editors are context sensitive providing auto-complete of SQL keywords and table or view columns.

visual query builder correlated subqueries dockable window data manipulation intelligent auto

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.

ntt docomo japan visual query builder database management tool space flight center hitachi japan

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

visual query builder excel csv csv text sql scripts

Universal SQL Editor is a powerful, yet easy-to-use graphical query tool for all database developers. It allows you connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, Sybase, etc., and edit SQL queries and scripts with code completion, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently.

graphical query tool db2 sql sql editor compliant databases

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 Code Completion, Form Vie

StelsCSV is a JDBC driver that allows to perform SQL queries and other JDBC operations on text files (CSV, DSV, tab-separated, fixed length etc). Using this driver, you can easily create a simple database consisting of plain text files. Also, the driver can be used for writing data importing programs and migration tools.

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.

Interactive SQL for MySQL is a powerfull database utility for building, executing and processing queries upon MySQ It allows: Build SQL queries using SQL Editor with SQL syntax highlighting and SQL Query History features; MDI interface; Build SQL queries using Visual QueryBuilder; Export resultset in various data formats (HTML, RTF, XML etc.); SQL query errors highlighting.

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

StelsMDB is a MDB JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on Microsoft Access database files (MS Access 2000, 2002, 2003, XP versions). The driver is completely platform-independent and does not require installing additional client or server software to provide access to MDB files. It can be effectively used to create, process and export Microsoft Access databases in your Java applications.

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.

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.

Quick Query 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.

Oracle 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 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view/edit BLOBs.

Allows any application, including DOS apps and batch files, 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.

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.

SQLite 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 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs.

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.

Aglowsoft SQL Query Tools includes three database tools. They are Aglowsoft Schema Tool, Aglowsoft Designer, and Aglowsoft Browser. The tools are designed to allow building of SQL queries with basic knowledge of SQL using user-friendly interface. Result sets from SQL queries are presented in a combination form of view trees and table views. Table data can be exported to ODBC database table, Access 2000 database, XML or HTML format.

MaxDB 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 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs.

StelsDBF is a DBF JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on DBF files (dBase III/ IV/ V, xBase, FoxPro). The driver is completely platform-independent and does not require installing additional client or server software to provide access to DBF files. It can be effectively used to create, process and export DBF databases in your Java applications.

EMS SQL Manager for DBISAM provides you with powerful tools for DBISAM Server administration and object management. Its Graphical User Interface (GUI) allows you to easily and simply create/edit all DBISAM database objects, run SQL scripts, manage users and administer user privileges, visually build SQL queries, extract and print metadata, export/import data, view/edit BLOBs, and supplies many more features.

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.

BlackBerry Database Viewer will help you to view the contents of your desktop databases like MS Access, FoxPro, dBase, Excel and any ODBC Compliant Database like Oracle, SQL Server on BlackBerry through the USB cable. It has two components: One works on Microsoft Windows based Computer (i.e. desktop side) and other on BlackBerry handheld (i.e. device side). Use the Windows program to transfer your database tables to USB cable connected Device.

ASPdatabase.net is a web-based program that enables remote database management. You can view, edit, delete and create new records in a database table. Also, you can create new tables, drop tables, add or delete columns in a table and run your own sql queries.

MyCon (MySQL Console) is an extremely powerful windows based graphical user interface (MySQL GUI) for administering and working with MySQL server databases from version 3.21.x to 5.x. This easy to use MySQL front-end client includes all the functionality and tools you will need to be productive in MySQL as a DBA, developer, manager, report writer or a general end-user.

The Web Log DB exports web log data to databases via ODBC. Web Log DB uses ODBC to perform database inserts data using SQL queries. Web Log DB allows you to use the applications you have become accustomed to such as MS SQL, MS Excel, MS Access etc. Also, any other ODBC compliant application can now be used to produce the output you desire. Use Web Log DB to perform further analysis and special softs.

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.

LivePerf is a customizable performance monitoring tool for servers and distributed systems, featuring: * Consistent view across vendors, operating systems and application versions. * Extracting and presenting custom data, extracted from SQL queries, Java applications and even command line tools. Also allows defining own statistics and displaying them in custom charts and tables. * Record monitoring sessions and analyse them later.

CompareData 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

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

dbAnalyst is a cross-platform database administration solution: from connection, to import, to schema translation, to export. Database administrators and developers can manage any database with just one tool, reducing the learning curve and saving time and money. dbAnalyst?s intelligent interfaces, feature-rich console, and query wizards make it simple and easy to use yet powerful for any database analysis task.

.NET tier generator that builds applications from easily constructed abstract models. CompileX .NET builds full tiers of code, schema, database, database access layers, business logic and user interface, xml, VB and C# source code. Everything needed in a full working application. The 'abstract model' is created intuitively in an extremely fast, easy manner. CompileX .NET is a true, complete, enterprise-level, multi-tier, application generator.

SwisSQL - Oracle to Sybase Edition is an automated migration tool to convert stored procedures implemented in Oracle PL/ SQL into equivalent Sybase Adaptive Server Transact SQL code. It automates more than 80% of the PL/ SQL code conversion into TransactSQL with very minimal manual intervention. SwisSQL migration tool removes the time consuming, tedious and error prone manual effort and provides great productivity benefit.

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.

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.

Whenever you need a free and easy component to build complex SQL visually, Active Query Builder is the best solution for application. Active Query Builder, a two-way query builder combine visual query building with direct SQL query editing, is a perfect choice for both SQL beginners and experienced query writers. Active Query Builder is available in Delphi VCL, ActiveX and Windows.Forms .NET editions and it is absolutely free!

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.