Migrate from Btrieve to SQL Databases

Run Btrieve and Pervasive.SQL applications with MS SQL, Oracle, and PostgreSQL databases, no code changes required

Download Trial
Watch a Sample Migration
Zero or Minimal Code Changes

Zero or Minimal Code Changes

BTR2SQL’s plug-in architecture ensures your application effortlessly works with a SQL backend. Migrate your Btrieve or Pervasive.SQL database to SQL (creating tables, indexes, relationships, and other components) using BTR2SQL’s GUI migration tool. Post-migration, BTR2SQL’s database driver works alongside your application, connecting your app to your new backend and translating Btrieve API calls into optimized SQL queries.

Lower Your Database Costs

Lower Your Database Costs

Don’t get stuck paying more and more to use old Btrieve databases. BTR2SQL allows you to move to lower-cost database offerings, such as Microsoft SQL Server, and PostgreSQL without rewriting your application.

Support Multiple Database Management Systems

Support Multiple Database Management Systems

BTR2SQL simplifies supporting multiple database management systems (DBMSes) from one application. BTR2SQL’s dynamic link library (DLL) lets your app connect with both Btrieve and SQL databases at the same time, allowing you to offer a modern DBMS with little investment.

Quick and Easy Migration

Quick and Easy Migration

BTR2SQL’s database migration toolset includes a GUI that helps you migrate your data and a verifier that ensures the migrated data matches what came from your Btrieve database. While you must eventually create data dictionary files (DDFs) to allow BTR2SQL to create SQL tables and indexes, you don’t need DDFs initially to run your application against a SQL backend. This allows you to offer the SQL-enabled version of your software to your customers as quickly as possible.

Key Features

Key Features

  • Native, optimized connections with both your existing Btrieve database and SQL.
  • Quick and easy migration, utilizing a GUI migration tool, DDFs, and database validation.
  • Full support for Btrieve-style locking (outside of transactions).
  • Advanced tracing support for easy troubleshooting using startup trace or trace API.
  • Support for Data Table Index (DTI) functions.

BTR2SQL seamlessly connects your application with the latest versions of industry-standard SQL databases. Use BTR2SQL to take advantage of countless SQL-enabled third-party tools and operating systems, while also supporting your business’s scalability and ongoing growth.

Supported PostgreSQL Versions
Supported PostgreSQL Versions

Version 9.1 and above

Supported Btrieve/Pervasive Versions

Version 9.1 and above

About

Are you currently working exclusively with Btrieve and Pervasive.SQL transactional engines?
Then BTR2SQL is the right product for you! It allows an existing application working exclusively with Btrieve and Pervasive.SQL to quickly function with a PostgresSQL database server. For those seeking support for stored procedures and functions, PostgreSQL provides an enterprise level database with absolutely no license fee or royalty.

Your 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.

Requirements
  • Accurate DDFs for migrating an existing database to the target backend
  • For your application to work accurately with the new database please ensure tables and indexes are created accurately on the target back end
Important Notes
  • BTR2SQL 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.
  • 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), must be corrected before migration.
Supported PostgreSQL Versions
Supported Oracle Versions

Oracle 9i and above
Oracle Express Edition

Supported Btrieve/Pervasive Versions

Version 7 and above

About

BTR2SQL is a technology bridge that allows an existing application that is currently working exclusively with Btrieve Pervasive.SQL transactional engines to quickly function with an Oracle database server by following a few easy steps. Mertech’s product offering enables developers using Btrieve and Pervasive.SQL’s transactional engines to offer their solution on an Oracle platform immediately.

Requirements

BTR2SQL requires accurate DDFs for migrating an existing database to the target backend. 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 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.

Supported PostgreSQL Versions
Supported MS SQL Versions

MS SQL Server 2005 and above

Supported Btrieve/Pervasive Versions

Version 7 and above

About

Recognizing the growing demand for Microsoft SQL Server on the Windows platform and the hurdles that developers using Pervasive’s Btrieve and Pervasive.SQL engines face in running their application with Microsoft SQL Server data source, Mertech has created a middleware solution designed for the following.

Requirements

BTR2SQL requires accurate DDFs for migrating an existing database to the target backend. 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 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.

Bank of America
Bank of America Migrates from Btrieve to Oracle with BTR2SQL
CDK Global Significantly Reduces Database Costs Using BTR2SQL Driver
CDK Global Significantly Reduces Database Costs Using BTR2SQL Driver

Migrate from Btrieve to SQL Without Source-Level Changes

Learn more about how easy it is to enable your Btrieve application to work with SQL databases