Mertech Flex2SQL Tech Blog

CL2SQL: Command Line Tool for Unattended Migration

Igor Guerrero — Wed, 20 Jan 2010 17:32:38 +0000

Mertech provides a command line tool to allow migration of data using Flex2SQL features without the GUI interface. The tool, called cl2SQL, is located in the Mertech\bin directory and supports all the options of Flex2SQL through command line parameters. A good use of this tool would be to convert an existing DataFlex databases to [...]

DF_TEXT data type mapping in Flex2SQL – performance considerations

gandalf — Fri, 18 Sep 2009 21:57:48 +0000

DF_TEXT fields are used in DataFlex to store text longer then 255 bytes. The number of DF_TEXT fields is limited by the maximum record length. This limit is higher in MS SQL Server then in a DAT file. There are though performance implications that should be considered before using SQL TEXT datatypes (VARCHAR(MAX), NVARCHAR(MAX) or [...]

Current Driver Releases

gandalf — Thu, 27 Aug 2009 17:25:10 +0000

The current driver releases for all of Mertech’s Flex2SQL products is as follows: Flex2SQL for Oracle (ver 10.0.3.22 updated 8/27/09) Flex2SQL for SQL Server 2008 and 2005 (ver 10.0.4.11 updated 8/27/09) Flex2SQL for MySQL 5 (ver 10.0.3.11 updated 8/27/09) Flex2SQL for PostgreSQL 8 and 7 (ver 10.0.2.17 updated 8/27/09) Flex2SQL for DB2 (ver 8.1.0.17 updated 2/21/06)

NULL Handling

gandalf — Mon, 17 Aug 2009 23:41:29 +0000

The concept of NULL in a database can be confusing. What is the difference between NULL and a blank value? How do you get a NULL into a field through Dataflex? How are blank values handled for types where a blank has no apparent meaning, for example with numbers or dates?

Multiple embedded SQL statements

gandalf — Tue, 30 Jun 2009 22:31:30 +0000

While complex embedded SQL statements will let you do a lot of work in one statement, it is sometimes necessary to nest SQL statements to get the job done. Using cursor handling lets you easily nest multiple embedded SQL statements.