Sql Queries Software

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

EMS Data Generator for DB2 is a powerful utility for generating test data to several DB2 database tables at once. The wizard application allows you to define tables for generating data, set value ranges, generate char fields and blobs, and many more features to generate test data in a most simple and direct way. It also provides you console application, which allows you to generate data in one-touch by using generation templates.

ems data wizard application db2 database blob fields wizard interface

FlySpeed Data Export 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!

compatible data source odbc data source ms sql server xml csv graphical user interface

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.

access database queries view additional information access queries query designer query area

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.

database administration solution rich feature set command line mode interactive sql sql scripts

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.

sql databases table permissions folder level native windows

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

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.

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.

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.

Navicat is a professional and intuitive database management tool lets you create, browse databases and run SQL queries in an easier way. This MySQL Client tool features an intuitive interface and provides a set of useful tool to manage, backup/ restore, import/ export data, Synchronize database and connect to remote MySQL server, etc.

SQLStomper is a SQL Database Explorer, a SQL Statement Generator, a Database Query Tool, and much more all combined into one simple application.

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

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.

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.

Interactive SQL for PostgreSQL is a powerful database software manager. 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.

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.

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

Lattice.DataMapper is a .NET based object persistence library for relational databases. Lattice.DataMapper bridges the gap between objects and data source and allows the developer to work at the object level with little knowledge of the data source. The data access is externalized in XML and can include both SQL queries and stored procedure calls. An API is provided to then dynamically store and retrieve .NET objects using the mapping definitions.

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.

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.

Interactive SQL for MySQL is a powerful database utility for building, executing and processing MySQL queries. 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.

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.

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 and doc) -Output to various devices (file, printer, fax, email, ftp).

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.

Universal Table Browser 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!

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.

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.

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.

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.

SQL Data Examiner 2008 is a multi-platform data comparison and synchronization solution. It merges selected databases with just a few clicks and saves hours of tedious manual work. The tool supports SQL Server including main innovations of SQL Server 2008, Oracle, MySQL and Access. You can compare not only table contents but also results of SQL queries. The command line utility makes it possible to run your day-to-day procedures automatically.

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.

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.

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

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.

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.

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.

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.

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.

SQL Examiner Suite 2008 compares and synchronizes both schema and data of SQL Server including the new SQL Server 2008. You can compare any version of SQL Server form 7.0 to 2008. SQL Data Examiner allows you to compare and synchronize not only SQL Server but also Oracle, MySQL and Access databases. Comparison with backups and SQL scripts, compare results of SQL queries, etc. Try it yourself!