Xplain2sql

More about Xplain2sql

Xplain2sql converts Xplain statements to SQL statements. More about this tool can be found in:

Supported SQL dialects

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, Borland InterBase, Firebird, DB/2, Oracle, PostgreSQL, SQLite 3, MySQL, ANSI-92 SQL, Microsoft Access and FoxPro:

  • PostgreSQL is very well supported. Tested against PostgreSQL 8.3.
  • MySQL 5 is also very well supported.
  • Microsoft SQL Server support is very complete.
  • FireBird support is reasonably complete although FireBird still lacks essential features such as the ability to create a temporary table in a stored procedure, so extends only work outside a stored procedure.
  • 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.
  • Quite complete DB/2 support. Non literal inits are currently missing.
  • Fairly complete Oracle support.
  • 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.
  • Generates Microsoft Access and FoxPro 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.

Contact me if you want support for other databases.

Download official release

The latest release is 4.0.1. It was released on 2008 August 19. There are downloads of sources, and binaries for various platforms.

xplain2sql source code downloads
DescriptionFile name
Full source, samples and documentation, no binaries. The source is written in Eiffel, you need to have the SmartEiffel 1.2r7 compiler installed to compile it. See the docs for details. Eiffel source tarball release
Eiffel zipped release
C source code (translated from Eiffel).
Type make and you have a binary for every platform that has a Standard C compiler. Type make xplain2sql-bcc to make a binary with the Free Borland C 5.5 compiler.
C source tarball release
C source zipped release
Samples, documentation and the man page in case you downloaded a binary). xplain2sql.doc.zip
User visible changes. NEWS
ChangeLog of xplain2sql. ChangeLog

xplain2sql binary downloads
PlatformFile nameVersion
Windows (compiled on Windows 2000 SP4 with Borland C 5.5) xplain2sql.exe 4.0.1
Linux Intel binary (compiled on Unbunty 8.0.4). Rename it to xplain2sql. xplain2sql-linux 4.0.1
Linux Intel debug binary (compiled on Ubuntu 8.0.4). Rename it to xplain2sql. xplain2sql-linux-debug 4.0.1
Mac OS X (thanks Mark Hissink Muller). xplain2sql-4.0.1_os-x.zip 4.0.1
Debian package (Ubuntu 8.04). xplain2sql-4.0.1-1_i386.deb 4.0.1

Download latest beta release

The latest beta release is 4.1.0. It was released on 20 December, 2011. There are downloads for sources and binaries for various platforms.

xplain2sql beta source code downloads
DescriptionFile name
Full source, samples and documentation, no binaries. The source is written in Eiffel, you need to have an Eiffel compiler to compile it. See the docs for details. Eiffel source tarball release
Eiffel zipped release
C source code (translated from Eiffel).
Type make and you have a binary for every platform that has a Standard C compiler. Type make xplain2sql-bcc to make a binary with the Free Borland C 5.5 compiler.
C source tarball release
C source zipped release

xplain2sql beta binary downloads
PlatformFile nameVersion
32-bit Windows (compiled on Windows 2000 SP4 with Microsoft C/C++ 12) xplain2sql-beta-4.1.0.exe 4.1.0
Debian package (Ubuntu 11.04). xplain2sql-beta-4.1.0-1_i386.deb 4.1.0
i686 Linux binary. xplain2sql-beta-4.1.0-linux 4.1.0
i686 binary debug version. xplain2sql-beta-4.1.0-linux-debug 4.1.0

Try it out line

You can now access Xplain2sql through a CGI interface. Try it now!

Support

Support for Xplain2sql is provided in the Xplain group.

Subscribe to Xplain
Powered by groups.yahoo.com
Or you can send a message to Xplain@yahoogroups.com.

Older releases

In case an older release has worked for you, but a newer one doesn't, here the previous releases:

  1. xplain2sql-3.0-csrc.zip: xplain2sql 3.0 zipped C source.
  2. xplain2sql-2.4-csrc.zip: xplain2sql 2.4 zipped C source.
  3. xplain2sql-2.2-csrc.zip: xplain2sql 2.2 zipped C source.
  4. xplain2sql-2.0-csrc.zip: xplain2sql 2.0 zipped C source.
  5. xplain2sql-1.3.0-csrc.zip: xplain2sql 1.3.0 zipped C source.

Note: on request, source or other format releases are also available.