DB2 and MySQL data transfer

If you are a DBA that manages both MySQL and ibm®db2®express-c, you need to understand the functional differences between the two database servers. This is the 4th installment in a series that helps DBAs with MySQL backgrounds Learn how to manage DB2 Express. In this article, learn about the differences in data transfer technology between the two products. The technologies discussed include Import, Export, Load, and other utilities specifically for data transfer.

Introduction and background knowledge

On July 28, 2006, IBM released the next DB2 for linux®, UNIX®, and Windows® version, a hybrid data server designed to meet today's complex business requirements. This version provides the first data server to support the industrial strength of native XML storage. Other features, such as compression, security, and autonomic functions, have also been improved.

An overview and in-depth discussion of the features supported by DB2 Express-c 9 can be found on the DeveloperWorks DB2 for Linux, UNIX, and Windows information management resources pages. These features include purexml™, a feature that ensures that organizations can take advantage of XML functionality in a native way. With the DB2 express-c 9 PureXML feature, you no longer need to store documents in large objects (lobs) or to break them into objects. Although IBM DB2 Express-c is well-suited to the needs of small and midsize enterprises, it does not provide all the features available in later versions. DB2 Express-c does not contain the following features in other DB2 9 versions:

· Replication (but support homogeneous Replication)

· Database Partitioning characteristics

· Connection Concentrator

· DB2 Geodetic Extender

· Query patroller

Net Search Extender

· Compression

· Label Base Access Control-lbac

Also, keep in mind that IBM DB2 express-c 9 is "free development", "Free Deployment", and "free release."

There are many improvements from DB2 Express-c 8 to DB2 express-c 9, and these improvements are beyond the scope of this article. However, the characteristics and functionality of data transfer remain largely unchanged. This article outlines the data transfer characteristics of IBM DB2 express-c 9.1. This article focuses on their functions and also mentions MySQL's data transfer capabilities. If you are familiar with MySQL data transfer, you can skip the "MySQL Data transfer" section to learn about IBM DB2 express-c 9.1 data transfer.

Topics for discussion-Overview

This article first introduces the data transfer in MySQL. Next, this article discusses the IBM DB2 express-c data transfer, which can be grouped into the following topics.

• Imports-Import utility and DB2 Load

• Exporting-Export Utility

• Other available tools