Freeware Directory

Freeware - Helper Applications - Databases

Studio is a GUI based dynamic execution environment for the 64bit database kdb+. It allows you to develop code inside a built-in advanced editor, and execute queries directly against kdb+ servers, all from within the editor. It can be used to develop k, ksql, sql and q code. It communicates with the kdb+ servers via tcp/ip. This allows queries to be executed against servers anywhere, so long as they can be reached by tcp/ip. Results sets can be viewed in the following formats: tabular; kdb+ console style; chart. Timing statistics for queries are also available. This program is now freeware, a license can be downloaded from the "Purchase" page.

Absolute Database - 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 ONLY.

dsn2csv offers the programmer a tool that allows for fast, flexible and simple access to the local host computer's ODBC table information. With dsn2csv you can export the local host ODBC table list to comma seperated values for output, redirect to a file or to the screen. You can easily add system calls to your program to execute dsnc2v and pipe it to a file for parsing, or utilize in a script to collect and utilize the Data Source table descriptions.

odbc2csv offers the programmer a simple, fast and effective method to collect DSN information from the local ODBC driver and output it to comma separated values. The csv output can be redirected to provide command line batch or script processing the information it needs to process Data Sources for sql export. Extract odbc dsn information easily!

Foxy SQL Free allows you to execute SQL commands and queries against any database, one query tool versus a lot of client/server applications. It is a fast-performing tool that allows database developers and administrators to create and manage databases effectively using an SQL script.

SQLyog is an easy to use, compact and very fast graphical tool to manage your MySQL database anywhere in the world. Whether you enjoy the control of handwritten SQL or prefer to work in a visual environment, SQLyog makes it easy for you get started and provides you with tools to enhance your MySQL experience. SQLyog is FREE for personal and commercial use.

Tables2csv offers the programmer a simple, fast and effective method to collect table information from the local ODBC driver and output it to comma separated values. The csv output can be redirected to provide command line batch or script processing the information it needs to process database tables for sql export. Extract sql table information easily!

MySQL++ is a C++ wrapper for MySQL's C API. It is built around STL principles, to make dealing with the database as easy as dealing with an STL container.

ASP Helper is a freeware ASP Code generation software that automates the redundant activities of the generation of ASP Code for adding, viewing, modifying, deleting etc. to and from either an Access or MS SQL Server Database. This software will save up to 70% of your ASP Coding time and improve the overall delivery time of the project. A must have for all ASP Programmers.

The program connects to an ODBC connection for viewing data, editing data, displaying field information, exporting the data in a table and importing the data that was exported. First step is to correlate an ODBC structure with an Alias. Create a new alias, select the Database Drive Name, enter a name of the Alias in place of the default name and select the path to the ODBC database.

FreeQueryBuilder is a GUI SQL client, written in 100% Java, with it you can create SQL queries without directly writing SQL. A diagram pane presents a graphic display of the tables you have selected from the data connection. It also shows any join relationships among them. When you make a change in the diagram pane, the SQL-Syntax pane is updated to reflect your change.

Ever wanted to add a Treeview to your Access application, but didn't know how? DataPig Instant Treeview does all the work, just point to your hierarchy table and a custom Treeview is created instantly. Best of all, you can incorporate this form into any one of your Access applications! .

The SQL Compare application will allow you to compare the structure of two SQL server databases and display all the differences between them. You can compare databases online or you can take snapshots of the structure of the databases and compare them off-line, which is ideal for when you regularly update a database and want to check that all the changes to the database were made successfully.

DaFT is a GUI to any database that can be connected via UnixODBC (linux) or ODBC (Windows). It's main purpose is exploring two or more databases at the same time to: copy records; analyze differences; create large automated insert scripts for backup or copying records; create and test queries for reports or custom triggers; or defining an interface between two databases. It provides list views of tables and columns, table view of data, an SQL statement editor with syntax highlighting and history memory of executed statements, variable scanning, CSV, HTML, SyLK, and DIF data format export, and a function for copying data between two ODBC databases.

PKLite is a Lightweight SQL querying tool written in Java. Connects to any JDBC compliant database and will run on any OS with a Java VM. Features: keyword highlighting, result formatting, statement history, multi-window, multiple databases connects at one time.

XMLtoDB lets you create DDL files from XML files which can then be used to create new tables in a database. You simply have to execute the DDL script in your favorite SQL editor and the new tables will be created.

Gold Fish.Net is a powerful tool developed with DBA's in mind. Through an easy to use interface wizards will guide you through such tasks as creating, editing, or modifying most database objects. Gold Fish.Net provides point and click navigation for exporting Data, Scripts, and Xml. Available modules are Schema Browser, Report Write, and Storage Manager.

MdbToMySQL is a tiny utility for all those programmers migrating a Microsoft Access database to MySQL. Just pick the MDB file and choose the tables to export. MdbToMySQL generates an SQL script file that can be easily imported via shell, phpmyadmin or similar tools. Also you have several options like structure/data export only and delete or truncate of tables before (re)creating and populating them. Requires: at least MDAC 2.6 and the Microsoft .NET Framework which are part of WinXP, will also run on WinNT & 2K if these components are installed.

CuteSQL is a freeware utility that allows you to connect to a database and execute SQL commands and queries. Available connections are Native, ODBC, & ADO. Key features include user-friendly interface; tabular displaying of SQL queries; running of saved scripts; history of used scripts; autocommit configuration; terminators settings. Directly supported databases: MS SQL; Oracle; Interbase; DB2 UDB; MySQL; Sybase; PostgreSQL; Firebird. Free registration code: casestudio2

A nice tool to synchronize a MySQL Webserver Database with a client Database without an ODBC connection between the webserver and the client. You only need FTP and php access to your webserver.

PrimeVision is one of the easiest and most powerful database editing applications available built with the developer in mind. PrimeVision connects to BDE, ADO and ODBC datasources for powerful editing, query building, data exporting, reporting and much more.