Migration tools

You can choose from various migration tools, depending on the task that you must perform.

• For in-place upgrades: You do not use any migration tools. Simply start the server by using the oninit utility. The data from the source database server is converted to the target database server automatically.
• For non-in-place migration: You can use distributed queries to move your data, or you can pick from a number of data transfer tools and utilities, such as:
  • dbexport and dbimport
  • onload and onunload
  • dbload
  • High Performance Loader (HPL)
  • External tables

  Each of these tools and utilities has specific advantages and limitations. Consider all of the variables and pick a tool or utility that is appropriate for your situation.

  You can use several different methods to move your data from non-IBM products to Informix®.