Database migration (Share 11)

Company recent data migration projects more, most of them are on cloud services, is basically mirrored on the cloud, P2V,V2V mode, but I also gradually learned that many enterprises also intend to database cloud services, due to various reasons, there is no way to P2V, v2v this form. We need to do an application migration that is a database migration.

The following sections describe the Oracle, MySQL, SQL Server database migration tools.

Oracle

First, Oracle SQL Developer is the Migration tool that Oracle uses to migrate non-Oracle databases to Oracle

The above tools are migrated to Oracle.

Specific steps:

1. Create a migration repository user in the Oracle database

The repository user is not the user who receives the MySQL migration data, but the user who makes the data migration configuration.

The Oracle Create User command is as follows:

Create user Migrater identified by Migrater;alter user Migrater account unlock;grant dba to Migrater;grant Connect, resour Ce to migrater;grant create session to Migrater;commit;

2. Create a new Oracle connection in SQL Developer

The connection to create Oracle in SQL Developer is simpler, as shown in:

3. Add a third-party jar package (MySQL)
To build a MySQL connection using SQL Developer, you need to add a MySQL driver package, adding the following method:

Click "Tools-" preferences "

In the Preferences panel, select the "database-third-party JDBC driver" on the left, click the Add Entry button below to select the MySQL driver jar package.

4. New MySQL Connection
After you add a third-party driver for MySQL, the configuration entries for MySQL appear in the New Connection page.

5. Associated Migration Data Archive
The migration repository needs to be associated before the database is executed, as follows:

Select Oracle Database--"porting repository----" Associated migration repository

Many tables are added to the newly created Oracle Database after association:

6. Porting MySQL database to Oracle database
Right-click on the MySQL database connection that requires data migration and select the "Migrate to Oracle ..." menu. Select Migrate database, database data type conversion, always next, to completion.

Second,

Database migration (Share 11)