Ensure Valid DDFs Before a BTR2SQL Migration

[fa icon="calendar'] Oct 30, 2018 4:01:00 PM / by Oliver Nelson posted in Btrieve

Before getting started with BTR2SQL, here's what you need to know about DDFs and the role they play in converting Btrieve/Pervasive files to SQL tables.  

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

Migrating a Magic uniPaaS application to an SQL backend

[fa icon="calendar'] Oct 23, 2018 8:08:00 AM / by Thomas Oatman posted in Btrieve

uniPaaS (now called Magic xpa Application Platform) from Magic Software Enterprises is a powerful application platform that simplifies the process of building and deploying business applications.  Although this platform has been available for many years and supports SQL databases, Btrieve tends to be the database of choice for Magic developers.

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

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 DataFlex, Btrieve, 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"]

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"]

Subscribe to Email Updates