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

Flex2Crystal saves USA Software hundreds of development hours

[fa icon="calendar'] Jul 10, 2018 2:17:42 PM / by Amanda McCluney posted in Case Studies

Here’s a scenario that anyone with tenure in the software business can relate to: you get the news that one of your most essential applications will be going in a new direction soon. In the case of F.A. “Woody” Spencer, President of USA Software, this news came from Crystal Reports, making the announcement that their long-used COM-based interface would soon be replaced with a .NET solution.

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

Using parameterized queries in DataFlex embedded SQL calls

[fa icon="calendar'] Jun 11, 2018 12:38:29 PM / by Matt Ledger posted in DataFlex

In Flex2SQL v15, we introduced the ability to use parameterized queries within your DataFlex application’s embedded SQL calls. Developers have been asking for this feature for a long time, and for good reason.

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

Enhanced Debugging and Tracing in Flex2SQL Version 15

[fa icon="calendar'] Jun 7, 2018 12:37:41 PM / by Matt Ledger posted in DataFlex

In Flex2SQL Version 15, we added support for sending your application's trace output to the Windows Debug Output.

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

Marketing in the GDPR era: 4 tips on the quest for compliance

[fa icon="calendar'] Jun 5, 2018 7:09:00 AM / by Amanda McCluney posted in News

Like so many other companies offering products and services to a global audience, the Mertech team recently turned our attention to data, privacy, and new data protection laws going into effect, such as the General Data Protection Regulation. The conclusion we drew was an easy one:

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

How to choose the right cursor type in embedded SQL calls

[fa icon="calendar'] May 29, 2018 8:31:24 PM / by Matt Ledger posted in DataFlex

Flex2SQL for Microsoft SQL Server allows developers to use either client-side or server-side cursors in their embedded SQL queries. In Flex2SQL Version 15, we significantly improved these queries' performance, so your DataFlex app can conduct embedded SQL queries even more quickly.  

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

Windows 10 Version 1803 Update Breaks Some Applications

[fa icon="calendar'] May 10, 2018 6:06:32 PM / by Oliver Nelson posted in News

We have received multiple reports of problems accessing database servers from within applications after updating Windows 10 to the latest version 1803. This same issue is being reported in DataFlex, VB6, VB.NET, Delphi, and other languages as well.

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

Subscribe to Email Updates