v 2.4 (12 June 2003) Release
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:
- SQL Anywhere.
Please take a tour and check Database Comparer screenshots
Added: 3-03-2003/6-10-2003 | Version: 2.4 | Downloads: 456/453/3
|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
|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
|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
|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
|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
|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
|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
|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 email@example.com and we will place your logo and company name in the source code
Added: 13-02-2000 | Version: n/a | Downloads: 2214/2214/1
|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
Added: 20-10-1998/25-01-1999 | Version: 2.56B2 | Downloads: n/a
|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
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:
- 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.
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:
- Problem with Paradox passwords fixed
- Few bugs (mostly minor) fixed
Added: 11-09-2002/13-11-2002 | Version: 3.4 | Downloads: 648/645/3
|© 1995-2006 Robert M. Czerwinski ( The Delphi Super Page a.k.a. DSP ).|
All rights reserved.