BOI Software Entwicklung und Vertrieb GmbH

Phone: +43 (0) 732 / 736423 - 0

Spazgasse 4


4040 Linz, Austria

Migration between relational databases

Migration of table data between relational databases

You have tables in relational databases and require them in another relational database on a different operating system?
You want to migrate table data of one database to a different database with different structure?
TABEX/4 offers you the tool to transport data between different relational databases. For example, you can maintain data stored in Oracle in DB2 or transport data from Informix to DB2.

fig. Example for a migration from Informix to DB2

Using TABEX/4 utilities TABN02 (command SQLTAB) / TABN05, data of the source RDB (in the example: Informix) are buffered in a TABEX DB (in the example: TABEX_DBi).

In most cases datatype conversions are needed. Therefore, an application program must be implemented to adapt the datatypes and save the table in another TABEX DB (in the example TABEX_DBd).

Using utility command SQLUPD, this TABEX_DBd is transferred to the target database (in the example: DB2).

If the corresponding table does not yet exist in DB2, it can be created in the target database using utility TABN06.
Please contact our support if you want to learn more about this feature.


Changes in ESA data spaces, efficient migration and a new success story: Learn more in our newsletter!


Migration Packages

BOI GmbH offers migration packages for the table management systems SPITAB, TABSYS and VTAS.


» Migration Packages

Success Stories

GDIS and BOI: Carrying on the Success

With TABEX4 JTC, GDIS has introduced the world's fastest Java interface for table access on customer and control data. Learn the details in our new Success Story.


» read this Success Story

» read more Success Stories