Migrating multi-company Btrieve applications with BTR2SQL

[fa icon="calendar'] Aug 16, 2018 9:11:00 AM / by Amanda McCluney posted in Btrieve

“What’s the best way to migrate a multi-directory Btrieve database to a SQL backend?” It’s a question that comes up often, considering that in SQL, different tables with the same names will collide if stored in the same database.

Read More [fa icon="long-arrow-right"]

BTR2SQL 5.3 makes Btrieve LOBs SQL-accessible

[fa icon="calendar'] Jul 26, 2018 10:19:13 AM / by Matt Ledger posted in Btrieve

Over the years, one specific portion of a Btrieve record has given some of our customers trouble. That's the variable portion, the bit that allows you to store up to 2GB of additional, unstructured data within a record using Large Objects (LOBs), in excess of the record's "fixed" 64K data limit.

Read More [fa icon="long-arrow-right"]

5 Must-Read Resources to Help IT Managers Prepare for GDPR

[fa icon="calendar'] Mar 12, 2018 5:16:14 PM / by Amanda McCluney posted in Btrieve, DataFlex, DevOps, Databases

With the May 25th deadline looming closer, it’s easy to find resources on the topic of the EU’s General Data Protection Regulation and what it will mean for organizations around the globe. In fact, a search query now yields so many results that it becomes overwhelming trying to sort through them all; some facts are repeated over and over, while other questions seem to go unanswered no matter how you search for them.   

Read More [fa icon="long-arrow-right"]

How Locale (Character Set) Choices Affect Your Btrieve Data in Oracle

[fa icon="calendar'] Mar 20, 2017 11:29:00 AM / by Mertech Data Systems, Inc. posted in Btrieve


Oracle's National Language Support (NLS) architecture allows you to store, process, and retrieve data in native languages.  Let's discuss these settings in more detail:
Read More [fa icon="long-arrow-right"]

Ensure Valid DDFs Before Migration

[fa icon="calendar'] Feb 14, 2017 10:01:00 AM / by Mertech Data Systems, Inc. posted in Btrieve

BTR2SQL requires valid DDFs to convert Btrieve/Pervasive files to SQL tables and migrate the data. It is absolutely essential the DDFs describe the entire layout of the data, or schema, within the Btrieve files.

Read More [fa icon="long-arrow-right"]

Troubleshooting Migration Utility Initialization Errors

[fa icon="calendar'] Apr 22, 2016 2:01:00 PM / by Mertech Data Systems, Inc. posted in Btrieve

Sometimes an error occurs (Error loading driver! in the screenshot below) when you select the target server in the BTR2SQL Migration Utility Login dialog box or the Migration Utility closes unexpectedly.

Read More [fa icon="long-arrow-right"]

Troubleshooting the lock plugin for MySQL

[fa icon="calendar'] Feb 23, 2016 8:17:00 AM / by Mertech Data Systems, Inc. posted in Btrieve

Mertech developed a MySQL plugin dll with a set of functions used at runtime to support record locking outside of a transaction. This dll must be installed on the MySQL server and the lock functions must be registered before the application can run properly. Guidelines for troubleshooting installation problems with the plugin are listed below.

NOTE: A more detailed explanation and a description of the mds_app_lock.ini file and lock functions can be found in the BTR2SQL User's Guide.

Read More [fa icon="long-arrow-right"]

How do I know if I am using the Pervasive or Mertech Btrieve dll?

[fa icon="calendar'] Jan 21, 2016 1:10:00 PM / by Mertech Data Systems, Inc. posted in Btrieve

As one of the last steps in the migration process, you substitute the Pervasive Btrieve runtime dll (wbtrv32.dll or later version called w3btrv7.dll) with the Mertech runtime dll of the same name. The Mertech runtime dll codes the standard Btrieve operations so that they will work with the new SQL backend.

Read More [fa icon="long-arrow-right"]


[fa icon="calendar'] Jan 19, 2016 8:59:00 AM / by Mertech Data Systems, Inc. posted in Btrieve

Mertech BTR2SQL comes with a software development kit (SDK) that gives you access to extended Btrieve functionality. The SDK contains a runtime dll and migration dll for each backend (MS SQL, MySQL, Oracle or PostgreSQL). The SDK also contains header files to define the constants and structures required for advanced programming and it contains detailed documentation and examples.

Read More [fa icon="long-arrow-right"]

Mertech Announces Release of BTR2SQL v5.2

[fa icon="calendar'] Jan 14, 2016 2:28:00 PM / by Mertech Data Systems, Inc. posted in Btrieve, News

Adds support for MS SQL 2014, LocalDB, Oracle 12c and PostgreSQL 9.4

Mertech Data Systems, the leading provider of high-performance middleware technology, is pleased to announce the release of v5.2 of BTR2SQL for Oracle, MS SQL, PostgreSQL and MySQL databases.

BTR2SQL allows applications utilizing Btrieve and Pervasive transactional interfaces to work with mainstream relational databases with minimal or no source level changes.

Read More [fa icon="long-arrow-right"]

Subscribe to Email Updates