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.
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.
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.
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.
Version 9.1 and above
Version 7 and above
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.
Oracle 10g and above
Oracle Express Edition
Version 7 and above
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.
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.
MS SQL Server 2008 and above
MS SQL Server Express
Version 7 and above
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.
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.
