For Windows platforms, the Migration Workbench provides you with the ability to use either Oracle8i Lite, the default repository, or Oracle8/Oracle8i/Oracle9i as the Migration Workbench Repository (repository). If you select the default repository, the Migration Workbench uses the Oracle8i Lite database that ships with the product.
If you select the Oracle8i/Oracle9i option, the Migration Workbench creates a repository in any Oracle8i or Oracle9i database. However, you must create a user in the Oracle database where you want to store the repository. The first time you log in to the Migration Workbench as this user, you are asked if you would like to create the repository. Any other time you log in to the Migration Workbench as this user, the user name and service are automatically defaulted for you.
You can switch from the default repository to an Oracle8i or Oracle9i repository without losing the data from a pervious migration. To switch from the default repository select File -> Switch Migration Repository. This brings you to the Oracle Migration Workbench Repository Login dialog box.
The Migration Workbench supports command line arguments that allow you to default the user name, password, and service fields. In the %ORACLE_HOME%\Omwb\bin\omwb.bat file you specify these fields using the following syntax: username=user password=password service=system. For example, you could append the appropriate start command line of the omwb.bat file with username=migration password=start service=mwbbuild. When you start the Migration Workbench the fields are automatically populated with these defaults. These must be valid arguments.
The elements of the login dialog box are as follows:
Oracle8i Lite is the default repository. For more information, see Using Oracle8i Lite as a Repository.
You must be able to connect to an Oracle instance.
Enter the user name for the repository. You must have already assigned connect and resource grants to the user. If you are using the default repository, a user name is not required.
Enter the password for the repository. If you are using the default repository, a password is not required.
Enter the service name that points to the Oracle database where you created the repository. A service name is only required if the Oracle database is located on a different system from where you are running the Oracle Migration Workbench. If you are using the default repository, this field is disabled.
Connects to the repository. If you are having problems connecting, see the Repository Troubleshooting topic.
Exits the Migration Workbench Repository Login dialog box without connecting.
Launches the Oracle Migration Workbench Quick Tour.
Launches the Informix Dynamic Server online help.
Related Topic