Enter a path or click Choose to select the location. Output Directory: The directory or folder in which all scripts generated by the migration wizard will be placed. Name: Name to be associated with this migration project.ĭescription: Optional descriptive comments about the project. A migration project is a container for migration objects. The Project page of the wizard specifies the migration project for this migration.
Truncate: If this option is enabled, the repository is cleared (all data from previous migrations is removed) before any data for the current migration is created. (For migrations other than from Microsoft Access, you should set the third party JDBC driver preference before creating the connection.) For example, create a database connection named Sales_Sybase to a Sybase database named sales.Ĭonnection: The database connection to the migration repository to be used. If you do not already have a database connection to the third-party database to be migrated, create one. Right-click the Migration_Repository connection, and select Migration Repository, then Associate Migration Repository to create the repository. (For multischema migrations, you must grant the RESOURCE role with the ADMIN option and you must also grant this user the CREATE ROLE, CREATE USER, and ALTER ANY TRIGGER privileges, all with the ADMIN option.)Ĭreate a database connection named Migration_Repository that connects to the MIGRATIONS user. If you do not already have a migration repository and a database connection to the repository, create them as follows:Ĭreate an Oracle user named MIGRATIONS with default tablespace USERS and temporary tablespace TEMP and grant it at least the RESOURCE role and the CREATE SESSION and CREATE VIEW privileges. The migration repository is a collection of schema objects that SQL Developer uses to manage metadata for migrations. The Repository page of the wizard requires that you specify the database connection for the migration repository to be used. On all pages except the last, enabling Proceed to Summary Page causes Next to go to the Summary page. Sometimes the wizard is invoked at a page other than the first step. The migration wizard is invoked in a variety of contexts, such as when you right-click a third-party database connection and select Migrate to Oracle or when you click Tools, then Migration, then Migrate. This is the recommended approach when performing a migration: you can resolve issues during these phases, and you can then inspect or modify objects to suit your needs. The Migration wizard provides convenient, comprehensive guidance through the actions that can be involved in database migration (capturing the source database, converting it to Oracle format, generating DDL to perform the conversion, and so on). 2.1.1 Migrating Using the Migration Wizard
0 kommentar(er)
