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



Comments

  1. 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
  2. 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
  3. 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
  4. in picture 8-9 the target must repositry schema?

    ReplyDelete
  5. 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
  6. It's so nice article thank you for sharing a valuable content
    Sql Server dba online training

    ReplyDelete
  7. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
    full stack developer training in annanagar

    full stack developer training in tambaram

    full stack developer training in velachery

    ReplyDelete
  8. You made such an interesting piece to read, giving every subject enlightenment for us to gain knowledge. Thanks for sharing the such information with us

    click here

    Selenium Training in Bangalore|
    Selenium Training in Chennai

    ReplyDelete
  9. Resources like the one you mentioned here will be very useful to me ! I will post a link to this page on my blog. I am sure my visitors will find that very useful
    python training institute in chennai
    python training in Bangalore
    python training institute in chennai

    ReplyDelete
  10. Thanks for the informative article. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.
    Blueprism training in Pune

    Blueprism online training

    Blue Prism Training in Pune

    ReplyDelete
  11. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.

    Data Science training in Chennai
    Data science training in bangalore
    Data science online training
    Data science training in pune

    ReplyDelete
  12. I think you have a long story to share and i am glad after long time finally you cam and shared your experience.

    devops online training

    aws online training

    data science with python online training

    data science online training

    rpa online training

    ReplyDelete
  13. Thanks For sharing a nice post about Oracle DBA Training Course.It is very helpful and Oracle DBA useful for us.Oracle DBA Training in Bangalore

    ReplyDelete
  14. This comment has been removed by the author.

    ReplyDelete
  15. This comment has been removed by the author.

    ReplyDelete
  16. Really a awesome blog for the freshers. Thanks for posting the information.microsoft azure training in bangalore

    ReplyDelete
  17. Thanks for sharing this, it was very informative, thank u so much…

    Start your journey with RPA Course and get hands-on Experience with 100% Placement assistance from Expert Trainers with 8+ Years of experience @eTechno Soft Solutions Located in BTM Layout Bangalore.

    ReplyDelete


  18. Hello, Good Article you know your article it's useful me and Thanks for Sharing Information.
    Oracle Institute in Delhi

    ReplyDelete
  19. Excellent! I love to post a comment that "The content of your post is awesome" Great work!

    digital marketing courses

    ReplyDelete
  20. Excellent blog with lots of information, keep sharing. I am waiting for your more posts like this or related to any other informative topic.Amazing web journal I visit this blog it's extremely marvelous. Interestingly, in this blog content composed plainly and reasonable. The substance of data is educationalData Science Training In Chennai

    Data Science Online Training In Chennai

    Data Science Training In Bangalore

    Data Science Training In Hyderabad

    Data Science Training In Coimbatore

    Data Science Training

    Data Science Online Training

    ReplyDelete
  21. Great Article
    Cloud Computing Projects


    Networking Projects

    Final Year Projects for CSE


    JavaScript Training in Chennai

    JavaScript Training in Chennai

    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete
  22. I wanted to thank you for this great read!! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you post.
    Database Developer Training in Bangalore

    ReplyDelete
  23. joined in this institution to do Pega training course. I used to attend weekend classes. I am satisfied with the institution as they guided me well. I refer this institution to others also to get better knowledge.My Trainer is the best trainer who guide me very well.Thank you sir

    Oracle training in bangalore

    ReplyDelete
  24. Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
    SQL Server DBA Training in Bangalore

    ReplyDelete
  25. Visit our website accessdatabasedevelopment.co.uk/ for develop custom databases tailored to your business needs and providing your business with a competitive advantage by enabling you to increase efficiency, enhance quality of service and make the work lives of staff simpler. We microsoft access database development London specialise in building bespoke business database solutions and form creation in ms access using industry standard tools such as Microsoft Access.


    ReplyDelete
  26. Great post. keep sharing such a worthy information.
    Web Designing Course In Chennai

    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.