Advanced Search - Program Type: Shareware - (Search in: Keywords) - Page # 1 of 1

FastTextSearch/IB is unique solution for the searching textual information in the Interbase database. Allow indexing an unlimited amount string and textual memo fields. Implements some idea from text retrivial systems - stop-word list, word stemming. Server side quick searching (without scan of all record). Possibility of use SoundEx for query. Independence from client software.

The Program XL Report Builder is a powerful and flexible tool for creating reports of any level of difficulty in the form of the Microsoft Excel Book. XL Report Builder allows to extract data simultaneously from several databases and to form a report on the basis of this data. Any database servers, which have ODBC - drivers, can be used as the data sources. The result of the program?s work will be a Microsoft Excel book, that?s why when creating a report you may use all power of the Microsoft Excel to give visual appearance to your data. Absolute and conditional formatting, automatic filter, summary tables, charts, calling of the VBA - macros ? and it?s not a full list of opportunities, which Microsoft Excel gives you for displaying of the information in your reports.
XL Report Builder differs from the Band-oriented report generating programs by the fact that it doesn't use such concepts as Footer, Header, and Detail. The whole process of report creation consists of two simple operations. The first is pointing out data sources, necessary for the report creation (choosing data from different databases using SQL-queries), and the second is creating of the book-template in the Microsoft Excel (XLS -template). The template contains the description of the report form, book options, sheet options and options of the separate areas of the report. There are some specially pointed out areas in the template, where (at creating the report) the data will be put. When the report execution process is started, XL Report Builder will load a template, fill in marked beforehand cells by the data from the pointed out sources and will show Excel on the screen. After this you can either print the report or save it on the disk as an .xls-file for the further work or analysis.

EMS Data Export for InterBase/Firebird is a powerful program to export your data quickly from InterBase/Firebird databases to any of 19 available formats, including MS Access, MS Excel, MS Word, RTF, HTML, XML, PDF, TXT, CSV, DBF and others. Data Export for InterBase/Firebird includes a wizard, which allows you to set export options for each table visually (destination filename, exported fields, data formats, and much more) and a command line utility to export data from tables and queries in one-touch.

Key Features:
- Exporting data to 19 most popular formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, ODF, SYLK, DIF, LaTeX, SQL, Clipboard and others
-Exporting data from several tables, views or queries at the same time
- Selecting fields to export and changing their order
- Adjustable parameters for each exported table and specific parameters for each output format
- Saving all export parameters set on current wizard session to the configuration file
- Command-line utility to automate your export jobs using the configuration file
- Latest InterBase/Firebird version support
- Connecting via local port forwarding through the SSH tunnel
- User-friendly wizard interface

Cross-database tool. Works via ADO or BDE. Tested on Paradox, dBase, FoxPro, ASCII, Lotus, HTML, InterBase, Oracle, SQL Server, MS Access, MS Excel, PostgreSQL, MySQL.
Main features are:
-Viewing, editing, and printing data.
-Building queries with tools for convenient writing the SQL statesments.
-Enhanced db grids, which allow to view and manipulate the data in the most convenient way.
-Creating, deleting, modifying BDE aliases.
-Several command line options.
-Searching and replacing text.
-Importing data to table from another table or a query.
-Exporting data from any open table or query to another database or file (with format conversion).
-Copying data to clipboard.
-Calculating numeric fields (sum, avg, min, max, count).
-Editing BLOB fields (MEMO, graphic).
-Tools for editing string fields (trimming, changing case of symbols).
-Sorting (logical and physical) data.
-Filtering data.
-Viewing structure with ability to print it.
-Reindexing tables.
-Customized data view (color, font style, temporarily hiding any column).
-Transaction control.

Cross-database tool with report builder. Works via ADO or BDE. Tested on Paradox, dBase, FoxPro, ASCII, Lotus, HTML, InterBase, Oracle, SQL Server, MS Access, MS Excel, PostgreSQL, MySQL.
Main features are:
-Viewing, editing, and printing data.
-Automatically created reports and convenient report builder (with templates, expressions, preview, etc.).
-Building queries with tools for convenient writing the SQL statesments.
-Enhanced db grids, which allow to view and manipulate the data in the most convenient way.
-Creating, deleting, modifying BDE aliases.
-Command line support for most important operations like exporting, query executing etc. Log of performed operations.
-Searching and replacing text.
-Importing data to table from another table or a query.
-Exporting data from any open table or query to another database or file (with format conversion).
-Copying data to clipboard.
-Calculating numeric fields (sum, avg, min, max, count).
-Editing BLOB fields (MEMO, graphic).
-Tools for editing string fields (trimming, changing case of symbols).
-Sorting (logical and physical) data.
-Filtering data.
-Viewing structure with ability to print it.
-Limited table restructure.
-Reindexing tables.
-Customized data view (color, font style, temporarily hiding any column).
-Transaction control.

Glaos is an interactive SQL tool for PocketPC, now it supports InterBase/Firebird and MySQL.
Glaos is intended for database administrators and developers: they can use standard SQL commands to access and manage data from desktop databases on PocketPC!
3-tier scheme allows to setup secure, fast and reliable connections and does not require any modifications in installed server software - you can install intermediate Glaos server on any suitable computer with installed database client and available internet access while your database server is placed at secure place.

EMS DB Extract for InterBase/Firebird is a powerful and easy-to-use utility for creating database backups in a form of SQL scripts. It allows you to save metadata of all database objects as well as table data. With flexible customization of the extract process you can select objects and data tables for extract and tune many other extract options. IB Extract includes a graphical wizard, guiding you through the extract process step by step, and a command-line service for creating backups in one-touch.

Key Features:
Support of Unicode data
User-friendly wizard interface
Selecting database objects for extraction
Possibility to define constraints for extracted table data
Possibility to insert statements for emptying tables before inserting extracted data
Extracting table data to SQL script as INSERT statements
Possibility to extract database objects in the correct order according to their dependencies
Possibility to compress the result script and split it into volumes
Possibility to select charset for the result file
Saving all extraction parameters set on the current wizard session
Command-line utility to extract metadata and data using the configuration file
Access to database through SSH tunnel

EMS SQL Management Studio is a complete solution for database administration and development. With components that focus on all critical database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering databases and managing database objects as well as for database migration, extraction, data import, export and comparison. SQL Studio unites these tools in one powerful and easy-to-use environment that can work round the clock. Whether you are a database or application developer, DBA or business analyst, EMS SQL Management Studio offers all essential tools to make you more productive than ever before!

SQL Studio Additional Features:
- Handy launch of utilities and services
- Storing all templates in a single repository
- Common data source list for all services and utilities
- Creating complicated tasks and scheduled tasks execution
- Ability to run external applications from scheduler
- Storing all task execution logs in one database
- Creating customized notifications with a variety of delivery options
- Ability to set visual interface style uniquely for all SQL Studio apps
- Fast access to EMS Technical Support Service

EMS Data Import for InterBase/Firebird is a powerful tool to import your data quickly from MS Excel, MS Access, DBF, XML, TXT and CSV files to InterBase/Firebird tables. It provides adjustable import parameters, including source data formats for all the fields and destination data formats for the selected fields, commit options, number of records to skip, etc. Data Import for InterBase/Firebird includes a wizard, which allows you to set all the import options for different files visually, and a command-line utility to execute import in one-touch.

Key Features:

- Import from 10 most popular formats: MS Excel 97-2007, MS Access, XML, DBF, TXT, CSV, MS Word 2007, OpenDocument Format and HTML
- Importing data to one or several tables or views from different databases
- A number of import modes - Insert All, Insert New, Insert or Update, and others
- UNICODE support
- Adjustable import parameters for each source file
- Saving all import parameters set on current wizard session
- Command-line utility to import data using the configuration file
- Powerful visual options module
- User-friendly wizard interface

EMS Data Generator for InterBase/Firebird is a powerful utility for generating test data to several InterBase/FireBird database tables at once. The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files, get lists of values from SQL queries and many other features to generate test data in a simple and direct way. It also provides you console application, which allows you to generate data in one-touch by using generation templates.

Features:

- User-friendly wizard interface;
- Generating data to several tables from different databases on one host;
- All data types support including BIGINT in Firebird 1.5 and BOOLEAN in InterBase 7.0;
- Different generation types for each field including list, random, incremental data generation and more;
- Ability to use SQL query results as list of values for data generation;
- Automatic control over referential integrity for linked tables data generation;
- Ability to set NULL values for certain percent of cases;
- Possibility of saving all the generation parameters, set on current wizard session;
- Command-line utility to generate data using the template file.

EMS Data Comparer for InterBase/Firebird is a powerful and easy-to-use utility for data comparison and synchronization. You can view all the differences in compared tables and execute an automatically generated script to eliminate these differences. Flexible customization of the comparison and synchronization process will enable you to select tables and fields for comparison and tune many other options. Data Comparer for InterBase/Firebird includes a graphical wizard, guiding you through the data comparison and synchronization process step by step, and a command-line service for synchronizing data in one-touch.

Key Features:

- User-friendly wizard interface;
- Data comparison for several tables at once;
- Automatic and manual selection of data to compare;
- Wide range of synchronization parameters;
- Partial data synchronization;
- Saving data synchronization script to file for future use;
- Possibility of saving all defined parameters, set on current wizard session;
- Command-line utility to compare and synchronize data using the configuration file.

EMS Data Pump for InterBase/Firebird is an excellent utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL Server, or any other database with ADO support) to InterBase/Firebird databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target InterBase/Firebird database and select tables for import. Database conversion becomes as easy as possible with Data Pump for InterBase/Firebird!

Key Features:

- Unicode data support;
- Source DBMS schemas support;
- User-friendly wizard interface;
- Converting database structure and data from any SQL servers or local databases, which have an ADO provider;
- Ability to create a new database or connect to the existing one;
- Selecting source tables, fields and indices for conversion;
- Fast generation of tables, fields and indices according to the source database structure;
- Easy customization of target database objects options;
- Ability to view and edit and save SQL script for generating target database;
- Full monitoring of database generation process;
- Selecting tables and their fields for data import;
- Multilanguage support.

dbExpress is a database-independent layer that defines a common interface to provide fast access to SQL database servers. For each supported server, dbExpress provides a driver as an independent library that implements the common dbExpress interfaces for processing queries and stored procedures. As a thin and simple data-access layer, dbExpress provides high performance database connectivity and is easy to deploy.

dbExpress driver for InterBase (DbxIda) provides access to InterBase, Firebird and Yaffil databases. It directly uses InterBase client software to connect to server. DbxIda supports InterBase starting with the version 5.x, Firebird 2.x, 1.x versions and Yaffil. Driver requires InterBase client to be installed on the client side.

Following development environments are supported by dbExpress drivers:

* CodeGear RAD Studio 2007
* CodeGear C++Builder 2007
* CodeGear Delphi 2007 for Win32
* Turbo Delphi Professional
* Turbo Delphi for .NET Professional
* Turbo C++ Professional
* Borland Developer Studio 2006 including support of Delphi for Win32, Delphi for .NET and C++Builder Personality
* Borland Delphi 2005
* Borland Delphi 8
* Borland Delphi 7
* Borland Delphi 6
* Borland C++Builder 6
* Borland Kylix 3
* Borland Kylix 2

Following the main features of our dbExpress drivers:

* Direct data access
* Ability to connect through native protocol without using client software (DbxOda and DbxMda)
* High performance
* Supports latest versions of servers
* All data types support
* Extended options for advanced behaviour
* Ability of monitoring query execution with DBMonitor
* Source code available
* Licensed per a developer without royalty fee
* One year free support for registered users

EMS DB Comparer for InterBase/Firebird is an excellent tool for database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to eliminate all or selected differences. Having EMS DB Comparer for InterBase/Firebird you can work with several projects at once, define comparison parameters, print difference reports, and alter modification scripts. Its user-friendly interface greatly simplifies discovering and eliminating differences in InterBase and Firebird database structure saving your time and therefore money.

Key Features:

- Full support of InterBase 7.5 & Firebird 2;
- Comparing databases on different servers as well as on a single server;
- Synchronous navigating between database objects with displaying the corresponding scripts for modifying databases;
- Browsing differences in a form of a script or grid;
- Ability to execute modification statements as one by one, as all together;
- Ability to edit modification statements and changing their order;
- Working with several compare projects at once;
- Saving and loading projects with all their parameters;
- A wide variety of options for comparison and synchronization;
- Built-in SQL Script editor with syntax highlight;
- New state-of-the-art graphical user interface;
- Ample opportunities for customizing your working environment;
- Keyboard templates for faster editing SQL scripts.

Interbase Converter will lighten your work with databases. Using it you can easily convert tables to data formats (xml, dbf, txt, and csv) and sql. In few steps you will create reports in xls, doc, html, and pdf. Interbase Converter allows you to change the selected captions to the ones you need or set header or footer for your files. For example, you may add the page number or company info to the bottom of each page. All these viewing and editing operations are quickly and easily done due to well-though wizard like interface. Interbase Converter has command line support (ActiveX included). Download your free evaluation copy of Interbase Converter now to get all the benefits.

IBXExTrees Library - components for work with InterBase/FireBird/Yaffil databases
with use IBX data access components.

Library contains following visible components:

========== OneTable Trees =============

1. TIBXExTreeView - DBTreeView component.
Nodes of Tree load from database after expand parents.
Supports:
- Simple/CheckBox/RadioGroup mode
- Internal Locate/sort dialogs and internal Popup menu for general edit operations
- Filtering nodes
- Custom sorting nodes in any order
- Easy replacing imageindex and stateindex
- Full Drag&Drop operation on tree/treelist and between trees/treelists
- Using additional custom fields
- Designtime metadata creator
In CheckBox/RadioGroup mode, check states of nodes stores in special checklist in memory.

2. TIBXExTreeColumnList - DBTreeView component with columns.
3. TIBXExTreeList - DBListView component.
4. TIBXExTreeComboBox - DBTreeComboBox component.

========= MultyTable Dinamic Trees ============

1. TIBXExDynTreeView - DBTreeView component.
2. TIBXExDynTreeColumnList - DBTreeView component with columns.
3. TIBXExDynTreeList - DBListView component.
4. TIBXExDynTreeComboBox - DBTreeComboBox component.

FIBExTrees Library - components for work with InterBase/FireBird/Yaffil databases
with use FIBPlus data access components.

Library contains following visible components:

========== OneTable Trees =============

1. TFIBExTreeView - DBTreeView component.
Nodes of Tree load from database after expand parents.
Supports:
- Simple/CheckBox/RadioGroup mode
- Internal Locate/sort dialogs and internal Popup menu for general edit operations
- Filtering nodes
- Custom sorting nodes in any order
- Easy replacing imageindex and stateindex
- Full Drag&Drop operation on tree/treelist and between trees/treelists
- Using additional custom fields
- Designtime metadata creator
In CheckBox/RadioGroup mode, check states of nodes stores in special checklist in memory.
2. TFIBExTreeColumnList - DBTreeView component with columns.
3. TFIBExTreeList - DBListView component.
4. TFIBExTreeComboBox - DBTreeComboBox component.

========= MultyTable DinamicTrees ============

1. TFIBExDynTreeView - DBTreeView component.
2. TFIBExDynTreeColumnList - DBTreeView component with columns.
3. TFIBExDynTreeList - DBListView component.
4. TFIBExDynTreeComboBox - DBTreeComboBox component.