Previous Topic Next topic Print topic


To migrate one or more databases

  1. Start the Migrate Utility.
  2. Click Commands > Migrate Database.
  3. From the Database list, click a database you want to migrate, or press Shift or Cntl as you click to select more than one database. This populates the Migrate Tables list with the tables defined for the database or databases you selected.
  4. To exclude one or more tables from the migration, on the Migrate Tables list, select the tables to exclude. To select one table, click it. To select more than one, press Shift or Cntl as you click. Then click Exclude. This puts the table or tables you selected onto the Not Included list. Optional.
  5. To include one or more tables that you previously excluded, on the Not Included list, select the tables to include. Then click Add. This places the selected tables back onto the Migrate Tables list. Optional.
  6. To set options for a table on the Migrate Tables list, click the table, then click Options. On the Table Options dialog box, set the options for the selected table, then click OK. Optional.
    Note:

    The default options for each table are those defined on the Default Options dialog box.

  7. Click Save. In the File name field, type a name for the .mig script file you want to contain the information you specified for this migration, then click Save. Optional.
  8. Click Execute to invoke the Run dialog box.
  9. From the To drop-down list, select a location to migrate to.
  10. Make any necessary changes to the migration options by checking or unchecking the appropriate checkboxes. Optional.
  11. Click OK to perform the migration.
Note:
  • If you choose to save the migration information, the Migrate Utility generates a .mig script file. The script file created here works the same as any other .mig script file except that you cannot view it in the Schema Viewer. However, you can execute it using the Execute Batch command or from the command line as often as you would like. You cannot execute a saved .mig script file from the from the Migrate Database dialog box.
  • Information pertaining to migration execution appears in the Execution Information window. Following successful migration, you can close this window.
Previous Topic Next topic Print topic