"Convert Xplain files to SQL with ease using Xplain2sql software." (11 words)
The software comes with a Delphi/ADO XSLT style sheet included, and the C source code release should compile on any platform with an ANSI C compiler. Binary releases for FreeBSD, BeOS, Linux, and Windows 2000 are provided as well.
Xplain2sql already supports a substantial subset of Xplain and is continuously extended until full support is reached. Currently, the program can convert from Xplain to Microsoft SQL Server, Inprise InterBase, DB/2, PostgreSQL, Microsoft Access, and ANSI-92 SQL.
Regarding platform-specific support, the software's compatibility with Microsoft SQL Server is very comprehensive, while its DB/2 support is quite complete with non literal inits being the only feature missing. More specifically, InterBase only supports literal inits, and the extend and value only work for a single user since InterBase does not have the concept of temporary table. On the other hand, PostgreSQL is quite complete with the new PostgreSQL 7.3 release, while the Oracle support, although initial, is fairly complete.
Xplain2sql also generates Microsoft Access data definition commands. Although the program supports generating good ANSI-92 SQL, inits with non-literal values cannot be supported by ANSI-92 because it does not have the concept of before and after insert triggers.
The latest release of Xplain2sql has much better code generation for count, min, max, and total functions using left outer joins instead of sub-selects. It also features a new extension to mimic SQL's insert into ... select. Moreover, extended attributes can now be updated for most dialects, while several bugfixes were implemented. Lastly, the package now includes an Ubuntu 8.0.4 package, allowing more users to enjoy the software.
Version 4.0.0: N/A