Running the Migrate Database Wizard

To run the migrate database wizard, complete the following steps:

Note: Begin with step 3 if your database is hosted on Microsoft SQL Server.

From the command line, fun the following and provide the password when prompted: sqlplus sys@<db_tns_names_entry> as sysdba
Go to p6suite\database\scripts\install\PM_<release_level>, and run manual_script_before_install.sql.
Go to the <P6_EPPM_Home>\database folder.
Run migrate.bat (with Windows) or migrate.sh (with UNIX or Linux).
Follow the prompts on each screen to provide connection information for the source database and the target database.
Note: When using an Oracle schema, the migrate database wizard allows you to create new tables or use existing tables in the target instance, but new schema users must be created through the migration process. The ability to map to existing schema users is not currently available through the migration process.