Mertech’s Flex2SQL ISAM to SQL Connectivity Drivers (ISDBC) drivers allow DataFlex applications to work with relational databases without requiring source level changes. Mertech’s plug-in architecture enables companies to quickly switch to a more scalable and secure database engine such as Oracle, MS SQL Server, MySQL or PostgreSQL without incurring high re-engineering costs.

Who Should Use It?

If you currently have a DataFlex application and are looking to change the database from DataFlex or Btrieve to a relational database without altering your application, then Mertech’s ISDBC drivers are the answer.

Flex2SQL for Oracle allows existing DataFlex® applications to connect to an Oracle® database server without requiring application level changes. The product uses Oracle’s Oracle Call Interface (OCI) for communicating and accessing the Oracle database, which is much faster than using an ODBC-based product.

Product Highlights

  • Support for overlap/partial overlap fields
  • Complete support for case sensitive indexes
  • Complete support for mixed ascending and descending index segments
  • Preservation of RECNUM values during data migration
  • High-speed data migration
  • Record Locking instead of file locking
  • Complete Support for Transaction
  • Access views and synonyms as DataFlex files
  • Seamless integration with existing TABLES and VIEWS by automatic generation of FD and TAG files from existing tables and views
  • NO CODE RECOMPILATION! The table structure is exactly like DataFlex!
  • Support for DataFlex restructure commands
  • Detailed migration report
  • Generate SQL Script for creating tables and indexes

Required Components

To be able to run a DataFlex program from any platform and connect to an Oracle database server, the user needs to install or have access to the Oracle SQL*Net client, properly configured to access the Oracle server. Mertech’s driver and license file is installed in the same directory as the DataFlex runtime and must also be accessible to the program.

Supported Oracle Version

  • Oracle® 9i and above, Oracle Express Edition

Supported Platform & DataFlex Versions

  • Visual DataFlex® 5 and above, DataFlex® 3.1c and above
  • Windows, Linux, HP and AIX
  • Please contact us for additional Unix platforms
SQLFlex® is a high-performance ISDBC driver for connecting to Microsofts MS SQL Server® database from DataFlex programs. The driver uses Microsoft’s SQL Server Native Client for communicating with and accessing the MS SQL Server database. We ship the SQL Server Native client and it is also available as a free small download from Microsoft. There is no need to buy additional drivers from other vendors, like in the case of ODBC.

Product Highlights

  • Support for SQL Azure
  • Support for overlap/partial overlap fields
  • Complete support for case sensitive indexes
  • Complete support for mixed ascending and descending index segments
  • Preservation of RECNUM values during data migration
  • High-speed data migration
  • Record Locking instead of file locking
  • Complete Support for Transaction
  • Access views as DataFlex files
  • Seamless integration with existing TABLES and VIEWS by automatic generation of FD and TAG files from existing tables and views
  • NO CODE RECOMPILATION! The table structure is exactly like DataFlex!
  • Support for DataFlex restructure commands
  • Detailed migration report
  • Generate SQL Script for creating tables and indexes

Required Components

To be able to run a DataFlex program from any Windows version of DataFlex the user needs to have the SQL Server Native client installed. Mertech’s driver and license file is installed in the same directory as the DataFlex runtime and must also be accessible to the program.

Supported MS SQL Server Versions

  • MS SQL Server 2005 and above (including LocalDB

Supported DataFlex Versions

  • DataFlex 5.x and above, DataFlex 3.1c and above
  • Windows 2000 and above
Developed using MySQL’s C API, Mertech’s ISDBC driver for MySQL provides complete support for various table handlers, file creation parameters, support for uppercase or lowercase object names and fast loading of data into tables using text files. DataFlex programs can take advantage of MyISAM tables which offer low-level ISAM access.

Product Highlights

  • Support for overlap/partial overlap fields
  • Complete support for case sensitive indexes
  • Complete support for mixed ascending and descending index segments
  • Preservation of RECNUM values during data migration
  • High-speed data migration
  • Record Locking instead of file locking
  • Complete Support for Transaction
  • Access views as DataFlex files
  • Seamless integration with existing TABLES and VIEWS by automatic generation of FD and TAG files from existing tables and views
  • NO CODE RECOMPILATION! The Table structure is exactly like DataFlex!
  • Support for DataFlex restructure commands
  • Detailed migration report
  • Generate SQL Script for creating tables and indexes

Required Components

To be able to run a DataFlex program from any version of DataFlex, the MySQL client library, libmysql.dll in Windows or libmysql.so in Linux should be placed in the same directory as Mertech’s driver and license file.

Furthermore, since Mertech’s product is not open source and does not follow the GPL licensing, users of MySQL with Mertech’s driver will have to purchase a commercial version of MySQL. Users are advised to check MySQL’s web site for more information on purchasing commercial licenses. Please see Mertech’s software license agreement for using MySQL commercial licenses.

Supported MySQL Versions

  • MySQL 5.0 and above.

Supported DataFlex Versions

  • DataFlex 5.x and above for Windows 2000 and above
  • DataFlex 3.1c and above Console Mode for Windows 2000 and above
  • DataFlex 3.1d for Linux and above
  • Please contact us for additional Unix platforms
For those seeking support for stored procedure and functions, PostgreSQL provides an enterprise level database with absolutely no licensing fee. Mertech’s driver provide access to stored procedures and functions from within a DataFlex program by using embedded SQL calls. For developers looking to adopt an enterprise level database with absolutely no license fee or royalty, PostgreSQL is the solution.

Product Highlights

  • Support for overlap/partial overlap fields
  • Complete support for case sensitive indexes
  • Complete support for mixed ascending and descending index segments
  • Preservation of RECNUM values during data migration
  • High-speed data migration
  • Record Locking instead of file locking
  • Complete Support for Transaction
  • Access views as DataFlex files
  • Seamless integration with existing TABLES and VIEWS by automatic generation of FD and TAG files from existing tables and views
  • NO CODE RECOMPILATION! The Table structure is exactly like DataFlex!
  • Support for DataFlex restructure commands
  • Detailed migration report
  • Generate SQL Script for creating tables and indexes

Required Components

To be able to run a DataFlex program from any Windows version of DataFlex, the user needs to install or have access to PostgreSQL client libraries and client networking utility, properly configured to access the PostgreSQL server. Mertech’s driver and license file is installed in the same directory as the DataFlex runtime and must also be accessible to the program.

Supported PostgreSQL Versions

  • Version 8.4 and above

Supported DataFlex Versions

  • DataFlex 5.x and above for Windows 2000 and above
  • DataFlex 3.1c and above Console Mode for Windows 2000 and above
  • DataFlex 3.1d for Linux and above
  • Please contact us for additional Unix platforms
Whitepapers Case Studies Download Webinars

Flex2SQL Blogs

Flex2SQL error accessing the PostgreSQL server

Problem An error message displays trying to access the PostgreSQL server: Cause Typically this problem is caused by missing dependencies for the PostgreSQL client library: Common Windows dlls: msvcr71.dll, msvcr80.dll,…

Posted in Flex2SQL, PostgreSQL | Leave a comment

Error when Binary Logging is Enabled in MySQL

Problem Several error messages may display during migration to a MySQL server when binary logging is enabled. The first message displays during index creation. A second message displays during data…

Posted in Flex2SQL, MySQL | Leave a comment

Default NULL value for date fields changed to 0000-00-00

The Mertech Flex2SQL GUI migration tool and Mertech drivers are being modified to use 00-00-0000 as the default NULL value for DataFlex DF_DATE and DF_DATETIME fields. Background The default NULL…

Posted in Flex2SQL | Tagged | Comments Off

Force Fields to NULL or Not NULL

Mertech’s ISAM drivers were developed always focusing on getting the best performance. We have been introducing many and different optimizations in all drivers, always looking for the best performance as…

Posted in Flex2SQL | Tagged | Comments Off

Embedded SQL using Mertech Drivers

Mertech has a comprehensive SQL command set for embedding SQL statements. Starting with v12.1, Mertech also provides a class layer that allows you to use the embedded SQL (ESQL) classes…

Posted in Flex2SQL | Tagged , , | Comments Off