MS SQL Server Migration to Oracle 10g




MS SQL Server Database to Oracle 10g Database Migration through SQL Developer.


1. Connect SQL Server from SQL Developer Tool.

Use this http://oracle-mssql-dba.blogspot.in/2012/05/sql-server-connection-from-oracle-sql.html







2. Check database from SQL Developer.







3.Click on SQL SERVER Database.Select Migrate to Oracle.




4.Follow the Steps Instructed below.







Select Repository Database







Truncate repository before create Fresh 

Choose Project Name and output directory

 
Choose Source Database.

 


Select Database to migrate 

 

Select/Change Data Type conversion Options

 


 Select target database option.





 Move Data from source to target database.

 


Check the summary.if any changes require then move back and change it

 

**Kindly note that sql server user should be owner of the migrated database.If not then it will through error.

**For Oracle User is different then SYS User.New User should have grant for dba role.






Check running process.




 Check the Status of migration Completed.







Its look something like this.

New User created dbo_SQLSERVER.

Connect and check the output.








Kindly check the output log file generated in /SQL_migration Folder



13 comments:

  1. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! Its always nice when you can not only be informed, but also entertained! Im sure you had fun writing this article.
    Valuable information and excellent design you got here! I would like to thank you for sharing your thoughts and time into the stuff you post!! Thumbs up
    http://www.sqlservermasters.com/

    ReplyDelete
  2. Hey very nice blog!!
    Hi there,I enjoy reading through your article post, I wanted to write a little comment to support you and wish you a good continuationAll the best for all your blogging efforts.
    Appreciate the recommendation! Let me try it out.
    Keep working ,great job!
    http://www.mindqonline.com/

    ReplyDelete
  3. My partner and i actually enjoy this post and the internet site all in all! Your piece of writing is really plainly composed as well as simply understandable. Your current Blog design is awesome as well! Would be awesome to know where I are able obtain it. Please maintain up the very good job. We all require far more such website owners like you on the net and much fewer spammers. Fantastic mate!
    Hadoop training

    ReplyDelete
  4. Thanks for Information Oracle 10g/11g Database Administration In this course, you will explore how an Oracle Database applies ‘grid computing’ to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. You will learn how to install, administer, and maintain an Oracle 10g or 11g database in an effective and efficient manner. You will cover the interaction among Oracle components, Oracle’s architecture, and user management. Performance monitoring, database security, and backup and recovery techniques are covered. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.Oracle 10g / 11g DBA Online Training

    ReplyDelete
  5. Thanks for giving Good Example It are very useful to us.
    Fantastic article, Viral. Very well written, clear and concise. One of the best links explaining one to many and hierarchy Sqlserverdba. Thanks a lot.It is useful to me and my training SqlserverdbaOnline Training

    ReplyDelete
  6. Thanks for giving Good Example It are very useful to us.
    Fantastic article, Viral. Very well written, clear and concise. One of the best links explaining one to many and hierarchy Sqlserverdba. Thanks a lot.It is useful to me and my training SqlserverdbaOnline Training

    ReplyDelete
  7. in picture 8-9 the target must repositry schema?

    ReplyDelete
  8. Thanks for providing this informative information you may also refer.
    http://www.s4techno.com/blog/2016/07/27/introduction-to-sql/

    ReplyDelete
  9. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle 11g, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Oracle 11g. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us:
    Name : Arunkumar U
    Email : arun@maxmunus.com
    Skype id: training_maxmunus
    Contact No.-+91-9738507310
    Company Website –http://www.maxmunus.com


    ReplyDelete
  10. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Microsoft SQL Server, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Microsoft SQL Server. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    MaxMunus
    E-mail: nitesh@maxmunus.com
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023
    http://www.maxmunus.com/


    ReplyDelete
  11. Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..
    SQL Server Training in Chennai

    ReplyDelete

Dear User,

Thank you very much for your kind response