Tools freeware
DataBase Programming

[ AddPassword.zip ] [ 393,747 bytes ]

[ Freeware ] [ No Source ]

This program was created to simplify adding/removing of Paradox table password.

Added: 18-08-2003 | Version: 1.0 | Downloads: 306/306/0

Author:

Waheed Al-Sayer Shamayel Computer Systems [Homepage] [DSP files]

[ ADOTableInfo.exe ] [ 1,373,120 bytes ]

[ Freeware ] [ No Source ]

ADOTableInfo is a free tool which print structure of any database using MSAccess or MSSQL via ADO or OLEDB. You can get a complete information about all database tables, fields, field types and primary keys. The resulting report can be saved to txt file or copied to windows clipboard. It's a very useful application for database analysis or documentation purposes.

Added: 20-10-2003 | Version: 0.7.2 | Downloads: 1118/1118/8

Author:

Dietmar Wintzheimer Wintzheimer SoftwareSysteme [Homepage] [DSP files]

[ bbdbd.zip ] [ 1,937,274 bytes ]

[ Freeware ] [ With Source ]

BB's Database Desktop is a utility like Borlands original Database Desktop (which is shipped e.g. with Delphi and which is not free). The goal of this project is to implement the functions of the original and add some usefull features. Full source and additional plugins can be downloaded from our homepage (http://bbdbd.sourceforge.net)
This is still a BETA version: It is important to understand that the beta release of any product will not display the stability of a final release. You may encounter problems with this release. This release is not appropriate for production use, and we st

Added: 25-04-2000/4-05-2000 | Version: 0.1.3.0 | Downloads: 2139/2127/10

Author:

Beat Bucheli [Homepage] [DSP files]
Pascal Berger [Homepage] [DSP files]

[ CREATEDB.ZIP ] [ 562,376 bytes ]

[ Freeware ] [ No Source ]

Weyhe, July 2001 DBCreate.exe copyright by Rolf Kurtz Program information: DBCreate is a tool for Delphi-Database programmers with the database basis of 'Paradox-Tables'. 1st with same, managed all in the database. 2nd imported. The 'Borland Database Engine' must be fitted. It is not guaranteed, that every structure is recognized correctly, however, all usual structures might be imported problem-free. The program is 'freeware' and may be used freely. The use occurs however on own danger ! It is not taken over from damage to any assurance for any kind that the use of the Prorammes is to be put down to. You should find program errors, I am thankful for a short E-Mail with corresponding error description. A lot of fun during the job with this tool. Rolf Kurtz E-Mail: rolf.kurtz@t-online.de

Added: 23-08-2001 | Version: 1.2 | Downloads: 1/1/0

Author:

Rolf Kurtz [DSP files]

[ d5cmpct.zip ] [ 204,690 bytes ]

[ Freeware ] [ With Source ]

This console utility repairs and compacts MS-Access databases version 97/2000 without the need of having Access installed. It uses the MDAC-RTM instead . This is usefull for scheduled batch files running on a file server. [more]
Delphi 5 source included.

Added: 26-11-2000 | Version: 1.0.1 | Downloads: 1703/1703/3

Author:

David Simpson, Bob Wasaff, Jobst Hensiek [DSP files]

[ DataMan.exe ] [ 854,269 bytes ]

[ Freeware ] [ No Source ]

Manage your databases easily! This tool will support you in your database management activities for dBase compatible tables with Clipper-, FoxPro- or HiPer-SIx format indexes. Supported functions are: Table creation, automatic generation of Table creation source code (for the BDE, Apollo and Advantage drivers), XML table export and conversion, conversion between Windows and DOS charset, table encryption, table structure printouts, structure conversions, packing tables & more. It also provides a level-access system so that you can even give it to your novice users and still lock some of the critical functions from them. IMPORTANT: please read the installed Readme file for details about the preconfigured access levels of this program in order to see its full functionality.
Freeware (Delphi 5 source code available for $125.00)

Added: 21-12-1998/30-12-2001 | Version: 2.1a | Downloads: 2219/1551/1

Author:

Inner-Smile.com [Homepage] [DSP files]

[ db2mysql.zip ] [ 468,329 bytes ]

[ Freeware ] [ No Source ]

Loading BDE-Tables(Dbase,Paradox,...) into mySQL-Databases

Added: 8-07-2002 | Version: 1.0.0.0 | Downloads: 845/845/2

Author:

Hans Pupp [Homepage] [DSP files]

[ dbc.zip ] [ 1,376,048 bytes ]

[ Freeware ] [ No Source ]

Database Comparer

Added: 3-03-2003/6-10-2003 | Version: 2.4 | Downloads: 456/453/3

v 2.4 (12 June 2003) Release

http://clevercomponents.com/products/dbcomparer/dbcomparer. asp

Database Comparer helps to compare, synchronize and update databases structure. You can compare one database with another database or database with SQL/DDL script or even two SQL/DDL scripts!

Database Comparer implements highly intelligent and robust synchronization algorithm. During first comparison step it takes Target database or Target SQL/DDL script and compare it to the Master database or Master SQL/DDL script trying to locate all structure differences and prepare final SQL script which will be applied to the Target and make its structure equal to Master structure.

At this stage Database Comparer extracts all objects, descriptions and links from both Master and Target structures and then compares actual objects from Master with objects from Target building final update SQL script. After final update SQL script is ready you can apply it to the Target database if it is available or just save it to the file and run it later.

Database Comparer also support batch mode so you can synchronize list of Target databases with given Master database or SQL/DDL script at one pass.

Database Comparer main features:

Can compare database with database, database with SQL/DDL script and SQL/DDL script with SQL/DDL script.
You can optionally select which objects (domains, tables, procedures, triggers etc.) should be compared.
Intelligent comparison with automatic results control after each phase provides excellent results even if Master and Target structures are very different and / or have many linked objects.
Original and proven algorithms to synchronize and update linked objects.
Batch mode for most operations.
Build-in additional functionality such as:
- database cloning
- data synchronization within selected tables
- drop all constraints or only constraints with specified type
- database backup/restore with batch mode support
- database validation
Ability to browse Master and Target structure trees and visually display the differences between them.
Final update SQL script can be edited or broken onto separate steps using built-in SQL editor with highlight feature. You can manually change steps order or optionally disable selected steps.
Detailed context help system included.
Native, highly function and powerful user interface.

If you are database administrator, developer or just need to support bunch of databases this tool is designed for you! It will not only save your time and money but also makes sure that you are not missing anything and will not get into serious problems which might be caused by database structure differences.

Database Comparer supports following servers / scripts:

InterBase
FireBird
Yaffil
SQL Anywhere.

Please take a tour and check Database Comparer screenshots

Author:

CleverComponents Team CleverComponents [Homepage] [DSP files]

[ dbsrep.zip ] [ 290,838 bytes ]

[ Freeware ] [ No Source ]

This program is for replacing of info in tables. You may create a list of replaces, so it will make replaces according to your list. More, you can make lots of such lists and manage them. You may filter records to search in. This program make it easy to perform different replaces at once. Requires BDE.
Homepage is http://bubble.pdc.ru/DBSrep.htm

Added: 24-07-2000 | Version: 1.0 | Downloads: 1068/1068/1

Author:

Serge Bublik [Homepage] [DSP files]

[ dbstruct.exe ] [ 369,791 bytes ]

[ Freeware ] [ No Source ]

DB Structure tool analyzes structure of any database using BDE (Borland Database Engine) alias. You can get a complete information about all database tables, fields, field types, primary keys, referential integrity rules and indexes. The resulting report can be saved to txt file or copied to windows clipboard. Very useful application for database analysis or documentation purposes.
Please visit Crystal Soft for more free stuff and Delphi tips & tricks.

Added: 17-12-2000 | Version: 11.12.2000 | Downloads: 1664/1664/3

Author:

Branislav Cobanov Crystal Soft Software Engineering [Homepage] [DSP files]

[ dbstructure.zip ] [ 483,074 bytes ]

[ Freeware ] [ No Source ]

dBStructure is a completly free database tool. It is designed especially for dBase data tables but, a lot of its features you can use with your FoxPro and Paradox tables. You can use it as a replacement for Borland's Database Desktop. In the future dBStructure will give you the access to databases through BDE and ODBC drivers.

Added: 3-03-2002 | Version: 0.86 | Downloads: 823/823/3

Author:

Janusz Popielewski Janusz Popielewski | ix [Homepage] [DSP files]

[ DBUpdater.zip ] [ 585,895 bytes ]

[ Freeware ] [ No Source ]

DbUpdater is a professional tool for synchronizing database structures. It is ideal for software farms which have the problem of taking the customer data structure synchronized with the actual database structure. DbUpdater will automate this non trivial process. All the process is governed by a set of configuration files where is possible to specify which objects (tables, stored procedures, views, indexes, .) synchronize and how (create, modify, delete, .).
DbUpdater is a professional tool for synchronizing database structures.

Added: 28-03-2005 | Version: 1.0.2 | Downloads: 71/71/2

Author:

angelo Era Soluzioni [Homepage] [DSP files]

[ dbwizard.zip ] [ 1,576,382 bytes ]

[ Freeware ] [ No Source ]

DB-Wizard is a database tool for developers. Features of DB-Wizard are: Filling tables with random data for test purposes. A lot of different fill options for each type of field are provided. Also supports filling of BLOB fields (Memo, Graphic...). Browse tables displaying additional information about the structure of the table and referential integrity information and view blob fields with different viewers. Perform SQL queries on a database. Empty a database completly without having to worry about contraints and relations between tables. DB-Wizard will delete every record from every table as long as no record or table is locked. Spool out tables into files. Spooling of BLOB field also supported. Spool data from files into tables. Spooling of BLOB field also supported. DB-Wizard works with files based databases as well as with SQL database servers. DB-Wizard was written in Delphi 4.0 C/S and needs BDE 5.0 or higher.

Added: 21-03-1999 | Version: 1.0 | Downloads: 3238/3238/3

Author:

Martin Geier Martin Geier [Homepage] [DSP files]

[ dsp75.zip ] [ 634,507 bytes ]

[ Freeware ] [ No Source ]

OD DSP is a Database Structure Printer. It analyses any database and returns its structure (tables, index def, referential integrity...). It can work against local and SQL database as well. It can also generate a data dictionnary describing all the database (optionnal). DPS 7.5 needs BDE 5 (compiled with D4 sr2).
Exchange-ware : Source code on request if you send me a personnal and original code of the same level.

Added: 6-02-1996/25-04-1999 | Version: 7.5 | Downloads: 2589/2546/2

Author:

Olivier Dahan [Homepage] [DSP files]

[ exptsql.zip ] [ 329,223 bytes ]

[ Freeware ] [ No Source ]

BDE ExportSQL 1.0. BDE ExportSQL is a wizard that will create a SQL script from a BDE alias, for uploading on SQL servers. The script can contain the table scructures and data, and there are many options available to customize the script creation. To be database independent, ExportSQL uses a "SQL Definition File (SDF)", which states different parameters for different databases. Each .SDF file in the EXE directory denotes a database which will appear in the Target database combo. You can look at them, as they are only INI files, and you can create your own for your database. Currently, ExportSQL come with definitions for Standard SQL and MySQL Server. Some BDE ExportSQL feature are: available) corresponding fields to NOT NULL (when UNIQUE) All the screen parameters can be saved on a "ExportSQL Definitions" file (ESD), to be loaded again when necessary.
This was developed in Delphi 4.03, so I think you will need the latest BDE to use it.

Added: 3-05-1999 | Version: 1.0 | Downloads: 2343/2343/2

Author:

Rangel Gustavo Reale [DSP files]

[ freesql.zip ] [ 429,905 bytes ]

[ Freeware ] [ No Source ]

Welcome to "Free SQL" from ABC Software Engineering. This powerful tool lets you query any ODBC data base. Select your database, then select your table from the dropdown list.
You can write several SQL statements in this window, you can highlight each portion and run it or run it as one single query
The query's that work on one database do not always work on the next as different databases use different types of SQL. You can get your updates at http://www.abc-software-engineering.com Please feel free to distribute this program with your own software. Email abc_soft@candw.ky and we will place your logo and company name in the source code

Added: 13-02-2000 | Version: n/a | Downloads: 2214/2214/1

Author:

ABC Software Engineering [DSP files]

[ link: index.asp ] [ size n/a ]

[ Freeware ] [ No Source ]

Interbase DataPump v 3.4 (4 November 2002) Release
Interbase DataPump allows you to pump data from any ADO/BDE/ODBC sources (such as dBase, Paradox, Access, MSSQL, Sybase, Oracle, DB2 etc) and native Interbase/Firebird databases into Interbase/Firebird databases easy, fast and painlessly with total control over the whole process.
You can generate SQL script to create Interbase/Firebird database based on your ADO/BDE/ODBC source. This tool will help you to migrate from Interbase 5.xx and older Interbase databases to the new Interbase 6.x/Firebird format. You can use it to pump data from one Interbase database to another. A "must have" utility for all Interbase/Firebird developers and administrators!
This is "One Hour Solution" - in most cases it takes even less than an hour to pump data to your Interbase database.

Added: 1-05-2001/13-11-2002 | Version: 3.4 | Downloads: n/a

Author:

CleverComponents.com [Homepage] [DSP files]

[ link: inst_d3.exe ] [ size n/a ]

[ Freeware ] [ No Source ]

Instant Report allows to create programs, forms and reports using VBScript/JavaScript/Perl/Pascal, ActiveX controls and Delphi components. Any Delphi package can be installed into design environment. Any VCL component can be used in scripts. Application was created entirely with Dream Controls - powerful shareware library for Delphi and CPB programmers. Full sources are available for purchase.

Added: 20-10-1998/25-01-1999 | Version: 2.56B2 | Downloads: n/a

Author:

Dream Company Dream Company [Homepage] [DSP files]

[ link: kqbsetup.exe ] [ size n/a ]

[ Freeware ] [ No Source ]

Query Builder provides an easy-to-use interface for building queries to databases. It features: - Native language user intreface for building queries, allowing non-experienced users to issue fairly sophisticated queries; - A lot of features which simplify process of query building: special value editors for date, time and list values, ability to get the list of available values from the query, query designer for sub-queries, etc. - Ability to save and to load created queries and to assign some textual description for built query; - Instant viewing of generated SQL queries and query results; - Ability to save the result dataset into several formats (text, DBF files, HTML) and to print it.
Presented Query Builder application is a demo example of the Simple Query technology. The Query Builder's source code is included in Simple Query installation package as sample application.

Added: 14-05-2000/19-08-2002 | Version: 2.0 | Downloads: n/a

Author:

Sergiy Korzh Korzh.com [Homepage] [DSP files]

[ ibpump34.zip ] [ 677,543 bytes ]

[ Freeware ] [ No Source ]

v 3.4 (4 November 2002) Release

Interbase DataPump allows you to pump data and migrate from any ADO/BDE/ODBC sources (such as dBase, Paradox, Access, MSSQL, Sybase, Oracle, DB2 etc) and native Interbase/Firebird databases into Interbase/Firebird databases easy, fast and painless with total control over the whole process.

You can generate SQL script to create Interbase/Firebird database based on your ADO/BDE/ODBC source. This tool will help you to migrate from Interbase 5.xx and older Interbase databases to the new Interbase 6(7)/Firebird format. A "must have" utility for all Interbase/Firebird developers and administrators!

Features added in:

v 3.4

Interbase 7 full support added. Please note that versions of Interbase DataPump prior to 3.4 will not be able to work with Interbase 7 correctly.
Some interface changes were made.

v 3.3

This version of Interbase DataPump can be found only on Interbase v 7.0 companion CD. Ironically v3.3 will not be able to work with Interbase v 7.0. Borland didn't released any test version of Interbase v 7.0 so we had no chance to run any tests of submitted version of Interbase DataPump with Interbase v 7.0.

Ability to create custom SQL for source database added
Ability to create custom SQL for destination database added
Ability to create custom SQL for destination generators added
Custom SQL Wizard for destination sources added

Features listed above gives you ability to update / insert / delete data located in destination database with data from source database. You also can execute all SQL/ DSQL statements on your destination database.
Please read help or take online tour for more details.

Generate SQL script: full support of additional (extended) BDE information added.

Now then you will generate SQL script to create Interbase / Firebird database based on your BDE source all information such as referral integrity, default values and checks will be collected and translated properly.

Generate SQL script: detailed warnings will be created for every situation when original source can not be translated to Interbase / Firebird completely (properly).
Generate SQL script: more detailed reports produced.
Generate SQL script: support of Graphic, Memo (these two just an extension of Blob type fields) and Binary field types added.
Generate SQL script: duplicated index names can be handled in three different ways.
Pump report will show at the end detailed statistic for every step / source including how many records was processed, delete, inserted or updated physically and numbers of errors occurred.
Support of DB/400 thru BDE (Easycom driver) added and tested. Many thanks to Ralf Grenzing for his great help and time.
Some interface changes were made.

Bugs fixed since:

v 3.3

Problem with Paradox passwords fixed

v 3.2

Few bugs (mostly minor) fixed

Added: 11-09-2002/13-11-2002 | Version: 3.4 | Downloads: 648/645/3

Author:

CleverComponents Team CleverComponents [Homepage] [DSP files]