Sunday, August 6, 2017

Migrating From AWS to Oracle Using SQL Developer

The Data Uploaded to the Cloud Vendor Amazon web services ( AWS ) But the client decided to move their data on-premises for the first sight you will think this is hard and needs  a lot of work but thank you SQL Developer and Jeff Smith and he is the product manage for SQL Developer amazing man by the way and crossfitter  at the same time :P

However Lets start :-


  •  Open SQL developer
  • Choose Database copy option from tools menu.


  • Select source database should be AWS
    • Provide hostname only for the AWS
    • Listener Port
    • DB Name
    • Username/Password 
    • Test your connection.
  • Select destination database should be Oracle 

  • Provide hostname only for the AWS.
      • Provide hostname/IP for the server.
      • Listener Port
      • DB Name
      • Username/Password 
      • Test your connection.



    • Press Next Button, if the migration done before on the same schema press replace and next.

                                        

    • Press Next after choose what you want to move, Data, Functions , Or trigger ... etc

    • Check Proceed to summary and Press the finish button the migration will start after this,  it will take some time depend on internet connection and data size.
    Enjoy the migration
    Osama Mustafa






    5 comments:

    1. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic.
      Ultrasonic Testing Courses in Chennai

      ReplyDelete
    2. Thank you so much for sharing this informative blog. Your technical information is really useful for me. Keep update your blog.
      Regards..
      Oracle Training in Chennai
      Oracle Training Institute in Chennai

      ReplyDelete
    3. Thanks for you sharing to spread out your knowledgeOracle Training

      in Chennai

      ReplyDelete
    4. Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.
      python training in chennai

      ReplyDelete