Xplain2sql converts files from Xplain to SQL. xplain2sql supports a very large subset of Xplain, and it can convert from Xplain to Microsoft SQL Server, DB/2, Inprise InterBase, PostgreSQL, Oracle, MySQL, or ANSI-92 SQL.
It can also generate an XML description of the generated SQL. This XML description can be used to create low-level middle-tier code.
A Delphi/ADO XSLT style sheet is included. The C source code release should compile on any platform with an ANSI C compiler.
There are binary releases for FreeBSD, BeOS, Linux, and Windows 2000.
Xplain2sql supports a very large subset of Xplain already, and it is continually extended until full support is reached. Currently it can convert from Xplain to Microsoft SQL Server, Inprise InterBase, DB/2, PostgreSQL, Microsoft Access, and ANSI-92 SQL:
· Microsoft SQL Server support is very complete.
· Quite complete DB/2 support. Non literal inits are currently missing.
· InterBase support for init works only for literal inits (so attributes don't work). And because InterBase doesn't have the concept of temporary table, the extend and value only work for a single user.
· PostgreSQL is quite complete with the new PostgreSQL 7.3 release.
· Initial, but fairly complete Oracle support.
· Generates Microsoft Access data definition commands. However, it seems impossible to run an entire script against an Access database. Having to run each create table statement by hand is quite tedious.
· Generates good ANSI-92, however inits with non-literal values cannot be supported by ANSI-92 because it doesn't have the concept of before and after insert triggers.
What's New in This Release:
· Much better code generation for the count, min, max, and total functions using left outer joins instead of sub-selects.
· A new extension to mimic SQL's insert into ... select.
· Extended attributes can now be updated for most dialects.
· A variety of bugfixes. Now includes an Ubuntu 8.0.4 package.
Product's homepage
Find us on Google+
