Install Oracle Database 9.2.0.1 or above.

From the directory where you installed Oracle SQL Developer, double-click on sqldeveloper.exe.

In the Connections tab, right-click Connections and select New Connection.

Enter system_orcl for the Connection Name (or any other name that identifies your connection), system for the Username and <your_password> for the Password, specify your <hostname> for the Hostname and enter orcl for the SID. Then click Test.

The status of the connection was tested successfully. The connection was not saved however. To save the connection, click Connect.

The connection was saved and you see the database in the list. Expand system_orcl.

Note: When a connection is opened, a SQL Worksheet is opened automatically. The SQL Worksheet allows you to execute SQL against the connection you just created.

Right click on Other Users and select Create User.

Enter OMWBREP for the User Name, omwbrep for the Password and Confirm Password, USERS for the Default Tablespace and TEMP for the Temporary Tablespace. Then click the Roles tab.

Select the Granted checkbox for the CONNECT role and scroll down in the list.

Select the Granted checkbox for the RESOURCE role and click the System Privileges tab.

Select the Granted checkbox for the CREATE SESSION and CREATE VIEW privileges and click Apply.

The OMWBREP user was created successfully.

Before you create the repository, you need to create a connection to the OMWBREP user. Right click Connection and select New Connection.

Enter omwbrep_orcl for the Connection Name (or any other name that identifies your connection), omwbrep for the Username and omwbrep for the Password and enter orcl for the SID. Then click Connect.

Now you can create the repository in this users connection. Right click on the omwbrep_orcl connection and select Associate Migration Repository.

The progress window appears.

Once the repository is built successfully, click Close.

Click OK.

Select Migration > Capture Microsoft Access Exported XML.

Click Browse... to find the XML file. The files are in the \SQLDev_HOS\Migration\files directory.

Select Northwind.xml from the list and click Open.

Click OK.

The objects are being captured. When done, click Close.

Under Captured Models, expand Northwind (Access).

Expand Northwind to see the list of objects that were captured.

Right-click the captured model Northwind (Access) and select Convert to Oracle Model.

The Set Data Map window appears which shows you the Source Data Type and what it will be converted to in the Oracle Model. Click Apply.

The conversion is performed. When done, click Close.

Expand Converted Model (Northwind).

Expand Northwind.

Under Converted Objects, right click Converted Northwind (Access) and select Generate.

The Oracle SQL is being generated. When done, click Close.

The SQL from the script is shown. Click the Run Script icon.

Select the system_orcl connection and click OK.

The results are display from the script execution.

Now that your scripts have run successfully, you can create a connection for the Northwind user. Right click Connection then select New Connection.

Enter northwind-migrated_orcl for the Connection Name (or any other name that identifies your connection), Northwind for the Username and northwind for the Password and enter orcl for the SID. Then click Connect.

Expand northwind-migrated_orcl.

Expand Tables.

Notice that the database tables that were converted to Oracle are listed. Select the EMPLOYEES table.

Select the Data tab.

Notice that there currently is no data in the table. You will migrate the data in the next topic of this tutorial.

Open a DOS command prompt and execute the following commands:

cd <location where files are>
oracle_ctl

The location of the files is \SQLDev_HOS\Migration\files\data

oracle_ctl is a bat file that contains statements to load the data. It uses sqlldr to load the data.

Switch to Oracle SQL Developer and click Refresh to see that the data has been loaded for the CUSTOMERS table.

The data for the table has been loaded successfully.