Home / DB2 to MySQL File Builder

DB2iToMySQL - Generate MySQL Table Definitions from IBM i DB2 Files

Complete this form to access the links to download the free utility

What is DB2iToMySQL?

 

( * required )
*First Name:
*Last Name:
*Email:
*Organization:

 

Please send me information on how to rapidly create web applications accessing MySQL and/or DB2 with WebSmart.

 

Please add me to the WebSmart technical mailing list for all the latest Websmart tips and techniques.

 

Which tools or languages do you use to create web applications?

 

 

DB2iToMySQL is a free web based utility that generates MySQL CREATE TABLE statements from physical file objects on your IBM i. Just type the name of a library then select the files to generate MySQL statements for. Choose whether or not the statements should generate to use the IBMDB2I engine or the MyISAM engine and then DB2iToMySQL will create the mySQL Create Table statements for you.

The IBMDB2I engine results in the MySQL table also existing as a Physical File, so you can access it with PHP as MySQL or with RPG as a regular Physical file (for example). You can then cut and paste it into a text file to run it with the mysql command, or import it into PHPMyAdmin. You will now have MySQL tables that are the equivalent of your i5/OS physical files.

Rapidly create PHP or RPG CGI web apps over MySQL or DB2 files with WebSmart. Learn more >>