Oracle 10g Database to SQL Server 2008R2 Migration



1.Download Microsoft SQL Server Migration Assistant for Oracle for migrating oracle 10g to MS SQL 2008.
Download Here Click

2.Extract SSMA for Oracle 5.2.zip

3.Install SSMA for Oracle 5.2.exe by click on it.

 

 

 


Choose Typical 





Install it















Finish the installation


4.Install SSMA for Oracle 5.2 Extension Pack.exe by click on it.

 

 

 Choose Typical

 

 

 

Select Instance of SQL Server 2008.

 

Enter Credential Details



When migrating from server side.use password for protection.Use Complex password.




















Select no to exit

5.Click on Microsoft SQL Server Migration Assistant for Oracle

6.Select New Project in File Menu.




7.Connect Oracle 10g Database.






User Should have necessary privileges.

 



8.Expand Database Schema.







9.Create Report.







Comments

  1. This page is continued with this link http://oracle-mssql-dba.blogspot.in/p/oracle-10g-database-to-sql-server_10.html

    ReplyDelete

Post a Comment

Dear User,

Thank you very much for your kind response

Popular posts from this blog

Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c

Oracle 10g/11g Linux:SMS the alert logs ORA- errors generated in timestamp

Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server.