Since their beginning, Freight Management Systems developed their TMS software using DataFlex, which was a fairly popular business application development tool at the time. However, in more recent years, the FMS team struggled to find developers who could help maintain their application, or evolve it into a cloud-based offering.
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.
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.
“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.
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.
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.
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.
In Flex2SQL Version 15, we added support for sending your application's trace output to the Windows Debug Output.
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: