Database Migration from SQL Server to Oracle using SQL Developer

  • First, Create user ”Migration” for migration repositery where sqldeveloper manages metadata for migration. Grant privileges to Migration user.

Create user Migration identified by migration

Default tablespace users

temporary tablespace temp;

grant all privileges to migration;

  • Right click on connection tab to Create new connection:

1

  • Now create a database connection repository for migration user. Enter migration user name and password. Set SID of your oracle database and test your connection. On successful status click on connect.

2

  • To create the repository right click on Repository connection, and select Migration Repository menu then click Associate Migration Repository.

3

4

  • Expand the database and select Third Party JDBC Drivers. And click on Add Entry.

5

  • Select .jar file located in jTDS folder. click OK.

6

  • Now create a connection for SQL Server database using SQL Developer.
  • Give connection name as SQL_Server.
  • Checked Use Windows Authentication check box.
  • Through Retrieve database you can select sql server database which want to migrate.
  • Test and Connect.

7

In case of Error: SSO Failed: Native SSPI library not loaded. Try this:

  • Open the JTDS 1.3.0 folder.
  • The ntlmauth.dll you will find inside the x86/SSO folder
  • The JtdsXA.dll you will find inside the x86/XA folder
  • Put the ntlmauth.ddl and JtdsXA.dll inside de Sql Developer/sqldeveloper/bin
  • Copy the jtds-1.2.4.jar to Sql Developer/sqldeveloper/lib
  • Copy ntlmauth.dll in java bin folder

Now create user in oracle db in which you want to migarate sql server database

  • Create user test identified by test;
  • Create database connection for test user.

8

Finally you can start migration.

  • Open sql developer.
  • Click Tools>Migration>Migrate

9

  • Migration Wizard will appear on your screen. Click Next

10

  • Select Migration_repository database connection.

11

  • Give a name for migration project and select a directory to write output.

12

  • Now select third party database connection SQL Server which you want to migrate. In case of online migration Migration wizard will perform all operations. If you select offline migration then Migration Wizard will generate all DDL scripts.

14

  • Select SQL Server database which we want to migrate.

15

  • Conversion window will appear. Which will convert source data types according to oracle model.

16

  • Select SQL objects to translate.

17

  • Choose targeted Database.

23

  • Select the source and target database.

19

  • Summery window will show you the migration detail. In case of any change go back and correct it.

21

  • Click Finish.
  • Migration process will start.

22

  • On successful migration message your sql server database is migrated to oracle.

Copying tables to Oracle:

  • Right click the table located in third party database and click Copy To Oracle
  • Select target database connection and click Apply button. If you checked Include Data check box then it will create table structure and move data.
  • Finaly, Copy to Oracle database is finished.

 

Installing Oracle 10g on Windows

 

Step by step installation guide for Oracle 10g, covering a typical installation scenario.

  • Login to your computer as an administrative user to be authorized to install, create and run database.
  • First, verify your system and software compatibility and then run the oracle universal installer setup.exe.
  • The oracle universal installation starts.

   2

  • Select basic installation to install oracle 10g database, For basic installation,you should specify the following:
  • Oracle Home Location: Enter the directory in which you want to install the Oracle Database 10g software.
  • Installation Type: Select Enterprise Edition.
  • Create Starter Database: Check the checkbox to create a database during installation.
  • Global database name: Use default name orcl and type your password.

1

  • Installer now verifies whether the system meets all the requirements for installing and configuring the software and resolves any reported errors before continuing. When all of the checks are successfully completed, click Next.3
  • A summary screen will appear. Click Install to start the installation.

4

  • The installation window will appear to show the installation progress.                      5
  • If you are creating a database then the Database Configuration Assistant starts automatically.

6

7

  • After the creation of the database, you can unlock the users, you want to use by clicking on Password Management or you can do it later.
  • Click Ok.

8

  • Click Exit

.9

Testing your Installation:

You use Enterprise Manager to perform common database administrator task

To test your installation completed successfully, do the following:

  • Enter following URL: http://<hostname>:1158/em
  • Login as sys user. Enter sys as the User Name and the password you specified at the time of installation and Login.

 10

  • The Licensing window. Scroll to the bottom and click I agree.
  • 11If, the Database Control Home Page appears the your Installation was successful.12

betala med ecoPayz på casinon