Moving data from one system to another

A number of situations occur in enterprise operations that might require moving data from one IBM i operating system to another.

Here is a situation that might require moving data from one system to another: a new dealership opens in a region, and some clients from one or two other dealerships might be transferred to the new dealership as determined by client addresses. Perhaps a dealership closed or no longer represents Spiffy Corporation sales and service. That dealer's inventories and required service information must be allocated to either the regional office or other area dealerships. Perhaps a dealership has grown to the extent that it needs to upgrade its system, and the entire database must be moved to the new system.

Here are some alternatives for moving data from one system to another:

  • User-written application programs
  • Interactive SQL (ISQL)
  • Db2 for i Query Management functions
  • Copy to and from tape devices
  • Copy file commands with DDM
  • The network file commands
  • IBM i save and restore commands