Begin the Migration

After you have completed setup, you are ready to begin migrating.

1. In the Connect to ASE window, select the source and target SAP ASE servers to which you want to connect.
2. If you have not started sybmigrate with the -m migrate command line argument, select the session type in the Session Type window.
3. The Object Selection window allows you to choose what types of database data you want to migrate.

   In the Object Selection window, you can set the Copy thread, create index thread, and work thread parameters from the Setting menu bar.

   In the Object Selection window, you can also request that sybmigrate Auto-Select Dependent Objects on your selected objects by right clicking the object tree node.

   When you expand the database data folder, there is a file for each path that you created during setup. Each file allows you to select the data you want to migrate for that particular database. You can choose from the following:

   • Database Data

     Note: If you choose to migrate database data, you must migrate all of it. If you deselect parts of the database data, you see an error message asking you whether or not you want to migrate database data.

     If you do not migrate the server data during setup, the Database Data selection is disabled.

   • Defaults

   • Rules

   • User-defined Datatypes

   • Tables

   • Indexes

   • Referential Constraints

   • Views

   • Stored Procedures

   • Triggers

   The Status field for these objects indicates whether or not the data has successfully migrated. “Success” indicates that the data has already migrated. “Initial” means that the migration has not yet begun. If you find an error in the data that has been migrated, you can reset the Status field to Initial so that the data migrates again. The validation process acts only on those objects that have been migrated successfully, so to begin the validation process without all of the data having successfully migrated, reset the Status field to Success. “Work in Progress” means that the object was selected for migration, but that the migration was not attempted because there was some error causing sybmigrate to exit abnormally.

   You can see whether or not the server data has been selected to be migrated, but this is for informational purposes only since the server data has already been migrated at this point in the migration process.

   When you have selected the data that you want to migrate, click Migrate.