BTR2SQL: BTRIEVE TO MYSQL
The MySQL driver is designed to run applications developed for Btrieve and Pervasive transactional engines to work with MySQL without incurring expensive re-engineering costs. Mertech's plug-in architecture enables companies to support multiple databases with the same source base, including Pervasive.
MySQL has been the most popular open source database in the market for a some time now. It is also gaining increasing momentum as an embedded Database for applications requiring less maintenance, small memory footprint and a lower cost of ownership. For Btrieve users, MySQL is a logical choice, and the BTR2SQL for MySQL product aims to simplify the migration to MySQL for customers looking to either switch from Btrieve/Pervasive or to offer MySQL in addition to their Pervasive based solutions.
Mertech's ISDBC driver uses MySQL's native C API for communicating and accessing the MySQL database. This provides the fastest access to MySQL without being dependent on installing and configuring an ODBC driver.
BTR2SQL requires accurate DDF for migrating existing database to the target back end. The BTR2SQL product bundle includes a database driver DLL and a GUI migration tool that takes existing Btrieve/Pervasive table structures and migrates them to the new database server. However, for your application to work accurately with the new database, it is important that the tables and indexes are created accurately on the target back end. The Mertech migration tool relies on the DDFs to get the database structure information; inaccurate DDFs will create inaccurate table structures.
To ensure the integrity of the DDF, Mertech provides a DDF Validation tool that checks for common issues in DDFs, such as the total length of fields not matching the Btrieve record size for the file, and generates a detailed report. However, if you might have valid but inaccurate information in the DDF (e.g. if field length or field type or index definitions do not match what the program is expecting), then such inaccuracies will have to be corrected before migration.
Highlights of Supported Features
- Supports all Btrieve API functions
- Supports B_CREATE command (creates fields from index definitions)
- Supports locking outside of transactions
- Supports all extended functions
- Ability to mix embedded SQL statements with native Btrieve function calls
- Supports DTI functions for creating table, indexes
- DDF and Migration validation tools
- SDK allows simultaneous access to both Btrieve and MySQL database
Supported MySQL Versions
- MySQL 5.1 and above