Xplain2sql

• More about Xplain2sql
• Supported SQL dialects
• Download official release
• Download latest beta release
• Try it out line
• Support
• Older releases

More about Xplain2sql

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

• The Xplain2sql manual.
• The IASTED 2000 paper Johan ter Bekke and I wrote about Xplain2sql.
• The presentation I gave at the IASTED 2000 conference about this paper.
• Or try out the online version!

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:

• Microsoft SQL Server support is very complete.
• 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.
• PostgreSQL is quite complete with the new PostgreSQL 7.3 release.
• Initial, but fairly complete Oracle support.
• Although there is support for MySQL 3 and MySQL 4, these versions are too primitive for xplain2sql. But support for MySQL 5 is fairly complete.
• 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 3.0. It was released on 2007 March 13. There are downloads of sources, and binaries for various platforms.

xplain2sql source code downloads

Description	File 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

Platform	File name	Version
Windows (compiled on Windows 2000 SP4 with Borland C 5.5)	xplain2sql.exe	3.0
Linux Intel binary (compiled on kernel 2.6.20, glibc 2.4). Rename it to xplain2sql.	xplain2sql-linux	3.0
Linux Intel debug binary (compiled on kernel 2.6.20, glibc 2.4). Rename it to xplain2sql.	xplain2sql-linux-debug	3.0
FreeBSD 4.x package (compiled on FreeBSD 4.11-STABLE)	xplain2sql-2.4.tgz	2.4
FreeBSD 6.2 binary (compiled on FreeBSD 4.2-RELEASE)Rename it to xplain2sql.	xplain2sql-freebsd	3.0
RedHat Linux RPM (compiled on RedHat Linux 7.1).	xplain2sql-3.0-1.i386.rpm	3.0
Solaris 10x86 binary. Rename it to xplain2sql.	xplain2sql-solaris10	3.0

Download latest beta release

The latest beta release is 3.1.1. It was released at 2007 December 10. There are downloads for sources and binaries for various platforms.

xplain2sql beta source code downloads

Description	File 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

xplain2sql beta binary downloads

Platform	File name	Version
Windows (compiled on Windows 2000 SP4 with Borland C 5.5.1)	xplain2sql-beta-3.1.1.exe	3.1.1
i686 Linux RPM.	xplain2sql-beta-3.1.1-1.i386.rpm	3.1.1
i686 Linux binary (compiled with glibc-2.4).	xplain2sql-beta-3.1.1-linux	3.1.1
i686 binary debug version.	xplain2sql-beta-3.1.1-linux-debug	3.1.1

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-2.4-csrc.zip: xplain2sql 2.4 zipped C source.
2. xplain2sql-2.2-csrc.zip: xplain2sql 2.2 zipped C source.
3. xplain2sql-2.0-csrc.zip: xplain2sql 2.0 zipped C source.
4. xplain2sql-1.3.0-csrc.zip: xplain2sql 1.3.0 zipped C source.

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