UNIX or Linux and Windows store data in different page sizes. When your migration involves different operating systems, you must export data and its schema information from one database server and import the exported data into the other database server.
The method that you choose for exporting and importing data depends on how much data you plan to move. All these methods deliver similar performance and enable you to modify the schema of the database. You can use the following migration methods:
To move an entire database, use the dbexport and dbimport utilities.
To move selected columns or tables, use the UNLOAD statement. Use LOAD when you do not want to change the data format.
To move selected columns or tables, use the UNLOAD statement. Use dbload to change the data format.
To unload data in page-sized chunks, use the onunload utility. Use the onload utility to move data to an identical database server on a computer of the same type.
To move selected columns or tables or an entire database, use the HPL.
For information on migration paths from some older database servers to intermediary servers before migrating to Version 10.0, see Database Server Migration Paths.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]