The Migrate Database wizard is a java-based tool that enables you to migrate data from a Microsoft SQL Server database to an Oracle database.
Use the Migrate Database wizard to:
- Import data into a newly created database.
- Repair a damaged database to correct database object issues (such as constraints or views).
Do not use the Migrate Database wizard to:
- Convert the database type from EPPM to PPM or from PPM to EPPM.
- Upgrade from one database version to another.
- Import data into an existing database.
- Correct data-specific issues.
- Correct schema-related issues. It is not ideal for large databases (more than 10 GB) due to the performance of the wizard. For larger databases, try first to manually resolve schema-related issues.
Before running the Migrate Database wizard, you must first run a schema validation on the database. See Running a Schema Validation on the Database for details.