Sql Queries Software

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.

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

MyISQL (ISQL for MySQL)

MyISQL (Interactive SQL for MySQL) is a database administration solution for managing MySQL(tm) 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.

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

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.

SQLite 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. This shareware is listed under business databases, tools category.

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.

Multi-DB Querier

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.

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. This shareware is listed under development components, libraries category.

StelsDBF - fast DBF JDBC driver (dBase,XBase,FoxPro)

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.

StelsMDB - fast MS Access JDBC driver

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.

PostgreSQL Code Factory

This business 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/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.

SwisSQL Console

AdventNet SwisSQL offers Console, an easy to use Graphical user interface tool to convert SQL queries from one dialect to another. DB Administrators and developers working with multiple databases can just type a query in one SQL dialect and view the equivalent query in different databases? dialects. It supports Oracle, MS-SQL Server, DB2, Informix, Sybase, MySQL, PostgreSQL and ANSI-SQL SQL dialects.The product has both Java & VB Editions

Active Query Builder ActiveX Edition

Active Query Builder is a .Net-ready ActiveX visual query builder component to build 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.

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

Active Query Builder Free Edition

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!

FlySpeed Data Export

This business software is the must-have tool to export your data quickly and easily. Being able to connect to almost any source database, FlySpeed Data Export is the best choice to export data to MS Excel, MS Access, Text, XML file and other popular formats. Easy-to-use, high performance, optimized for repeated use. Download now and get your data exported in seconds!

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.

SwisSQL - SQL Server to Oracle Migration Tool

SwisSQL- SQL Server to Oracle Edition is an Automated Migration tool to convert Microsoft SQL Server Transact SQL stored procedures to Oracle PL/SQL equivalent code. It automates more than 80% of the code conversion with very minimal manual intervention. SwisSQL migration tool removes the time consuming error prone manual effort involved in typical migration projects and provides greater productivity benefit.

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.

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.

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)

MyCon Pro

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.

CompileX .NET

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

Absolute Database

This software - Delphi database system. This BDE alternative is free for personal use. Key Features: No BDE; no DLLs SQL'92 (DDL & DML) support Single-user and mutli-user mode (file-server) Single database file Unmatched ease-of-use 100% compatibility with standard DB-aware controls Strong encryption BLOB compression Full source code available Royalty-free Free for personal use

GiPo@DB_Utilities for Windows

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

Universal Table Browser

This office and business application is a fully functioning Query Tool giving you access to any database using ODBC. A graphical user interface means that you can simply point and click your way to complex SQL statements or use the SQL editor to write your own query. The browser has been optimized for MASSIVE databases, capable of dealing with MILLIONS of rows and thousands of columns and is capable of delivering data to you at blistering speed!

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

BlackBerry Database Viewer

This office software 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.

3 tier FrontEnd for MS-Access

Its based entirely on the n-tier technology. One at least application server must be istalled near the MS-Access database. The clients can be installed anywere in the Internet. Firstly the server installation gets all the database schema i.e. tables, fields, indexes, foreign keys and views. After that browsing and editing forms are created. The clients then are setuped automaticaly.

ASPdatabase.net

This software 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.

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.

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.

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.

EMS SQL Manager for DBISAM

This development tool 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. EMS SQL Manager for DBISAM is licensed as shareware and filed in database utitlities, database management, database tools, development databases, networks section.