Use SQL Developer to port SQL to Oracle (3) (1)

This article introducesSQL ServerPart 3 of porting:Database migrationWizard.

1. Establish a connection to the source SQL Server database

In the connection window, click the green plus sign to open the connection Configuration window and press the connection established to SQL Server:

Because of the use of dynamic products, the default 1433 on the original SQL Server configuration page is often unable to connect to the SQL Server 2008 database and change it to 1434.

Ii. Start the database migration wizard

After establishing a connection to SQL Server, start to port the database. You can start the database migration wizard in two places. One is to right-click the newly created SQL Server connection and choose portOracleThe other is in the menu tool-transplantation. After the Wizard is started, the first page is of course the wizard introduction. Through the introduction, we can know that there are 7 steps in the porting process, there are two prerequisites, for example:

Click Next.

3. Select the archive

On this page, we can also establish connections and archive, that is, the work we have done in the previous section can also be done here. Of course, select the migrations connection we just created, for example:

Truncation means clearing the archive. After a migration project is created, all the captured database structure information, statistical information, and conversion records are saved in this archive, as long as the project name is different, even if the empty data file library does not affect the migration. Of course, you can also select this option if you want to make it more "fresh. This is a post.

4. Name the conversion project

After selecting the archive, click Next and enter the name and remarks for the conversion project for identification. In addition, you must specify the script generation directory to store the scripts generated during wizard execution.

5. Select source database connection

Then proceed to the next step and select the source database. There are two modes: Connection and offline. Online means directly connecting to the source data for capturing, offline, when SqlDeveloper does not directly connect to the source database, it uses the script provided by SqlDeveloper to pre-capture the database. After obtaining the database structure file, it imports it through the wizard.

Select the SQL Server connection we just created.