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. AnonymousApril 29, 2013 at 5:49 PM

    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. magnifictrainingAugust 7, 2013 at 6:05 PM

    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. UnknownFebruary 11, 2016 at 4:36 PM

    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. MacrosoftJuly 19, 2016 at 2:31 PM

    Good information about sql developer tool.

    Microsoft Access to SQL Server Migration

    SQL Server Migration Assistant

    SQL Server Migration

    ReplyDelete
  5. UnknownNovember 3, 2016 at 6:16 PM

    in picture 8-9 the target must repositry schema?

    ReplyDelete
  6. UnknownMarch 16, 2017 at 11:59 AM

    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
  7. KavithaJanuary 3, 2018 at 1:32 PM

    nice post very interesting SQL Server DBA Online Training hyderabad

    ReplyDelete
  8. UnknownFebruary 3, 2018 at 5:12 PM

    It's so nice article thank you for sharing a valuable content
    Sql Server dba online training

    ReplyDelete
  9. MacrosoftFebruary 23, 2018 at 10:55 AM

    This is great guidelines for ms sql server migration to oracle 10g.

    Visual FoxPro to .Net
    VB.Net Migration
    VB6 Migration
    SQL Server Migration

    ReplyDelete
  10. AnonymousSeptember 3, 2018 at 4:43 PM

    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
  11. UnknownSeptember 7, 2018 at 6:55 PM

    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
  12. MounikaSeptember 8, 2018 at 3:54 PM

    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
  13. UnknownSeptember 17, 2018 at 11:05 AM

    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
  14. nilashriSeptember 18, 2018 at 12:00 PM

    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
  15. UnknownOctober 9, 2018 at 4:49 PM

    Really you have done great job,There are may person searching about that now they will find enough resources by your post
    angularjs Training in bangalore

    angularjs Training in bangalore

    angularjs Training in btm

    angularjs Training in electronic-city

    angularjs online Training

    ReplyDelete
  16. jefrinJanuary 9, 2019 at 3:34 PM

    wow nice post very useful
    SQL DBA training in chennai

    ReplyDelete
  17. rohiniJanuary 11, 2019 at 1:46 PM

    I simply want to give you a huge thumbs up for the great info you have got here on this post.
    apple iphone service center in chennai | apple iphone service center in chennai | apple iphone service center in chennai

    ReplyDelete
  18. cynthiawilliamsJanuary 23, 2019 at 6:18 PM

    Very nice post with lots of information. Thanks for sharing this updates.
    AWS Training in Chennai
    AWS course in Chennai
    DevOps certification in Chennai
    DevOps Training in Chennai
    Data Science Course in Chennai
    Data Science Training in Chennai
    AWS Training in OMR
    AWS Training in Porur

    ReplyDelete
  19. sasitamilMarch 11, 2019 at 3:05 PM

    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
  20. MacrosoftMarch 20, 2019 at 11:20 AM

    This is good guidance for MS sql server to oracle 10g.

    Visual FoxPro to .Net
    FoxPro to .Net
    Visual FoxPro Migration
    FoxPro Migration

    ReplyDelete
  21. Thomson PeterSeptember 9, 2019 at 3:20 PM

    I have gone through your post and I found it very helpfull. Looking forward to see more post from you.

    Cloud Migration services
    Aws Cloud Migration services
    Azure Cloud Migration services
    Vmware Cloud Migration services
    Database Migration services


    ReplyDelete
  22. Training for IT and Software CoursesNovember 3, 2019 at 11:40 AM

    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
  23. VictoriaNovember 28, 2019 at 8:37 PM

    This comment has been removed by the author.

    ReplyDelete
  24. VictoriaNovember 28, 2019 at 8:37 PM

    This comment has been removed by the author.

    ReplyDelete
  25. VictoriaNovember 28, 2019 at 8:44 PM

    Could be a part of vmware backup and recovery process.

    ReplyDelete
  26. JohanDecember 3, 2019 at 11:31 AM

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

    ReplyDelete
  27. Bhanu SreeDecember 11, 2019 at 2:52 PM

    It was so nice article. I was really satisfied by seeing this article.
    SQL Azure Online Training
    Azure SQL Training
    SQL Azure Training

    ReplyDelete
  28. eTechno Soft SolutionsDecember 15, 2019 at 7:32 PM

    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
  29. ReethuJanuary 2, 2020 at 10:20 PM

    NIce post. Keep sharing.
    Machine Learning training in Pallikranai Chennai
    Pytorch training in Pallikaranai chennai
    Data science training in Pallikaranai
    Python Training in Pallikaranai chennai
    Deep learning with Pytorch training in Pallikaranai chennai
    Bigdata training in Pallikaranai chennai
    Mongodb Nosql training in Pallikaranai chennai
    Spark with ML training in Pallikaranai chennai
    Data science Python training in Pallikaranai
    Bigdata Spark training in Pallikaranai chennai
    Sql for data science training in Pallikaranai chennai
    Sql for data analytics training in Pallikaranai chennai
    Sql with ML training in Pallikaranai chennai

    ReplyDelete
  30. AtulJanuary 14, 2020 at 3:40 PM



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

    ReplyDelete
  31. imexpertApril 17, 2020 at 11:48 AM

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

    digital marketing courses

    ReplyDelete
  32. nishaMay 23, 2020 at 11:24 AM

    Great Article. the article is very Informative and the contents are unique.

    Data Science Training Course In Chennai | Data Science Training Course In Anna Nagar | Data Science Training Course In OMR | Data Science Training Course In Porur | Data Science Training Course In Tambaram | Data Science Training Course In Velachery

    ReplyDelete
  33. aarthiJuly 19, 2020 at 6:46 PM

    Diagramatic explanation is very useful.Keep posting like this.
    Java training in Chennai

    Java training in Bangalore

    Java training in Hyderabad

    Java Training in Coimbatore

    Java Online Training

    ReplyDelete
  34. deviJuly 28, 2020 at 12:02 AM

    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
  35. Jagna Co KalaniAugust 12, 2020 at 1:00 PM

    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
  36. Ria Training InstituteJanuary 28, 2021 at 7:26 PM

    Fabulous..!!! The information you Provided is much useful. Sap Mm Training Institute In Bangalore | Dot Net Training Institute In Bangalore | Selenium Training Institute in Bangalore

    ReplyDelete
  37. Realtime ExpertsFebruary 6, 2021 at 11:55 AM

    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
  38. UnknownFebruary 11, 2021 at 12:33 PM

    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
  39. Realtime ExpertsFebruary 12, 2021 at 12:59 PM

    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
  40. Mindful GuidesJune 1, 2021 at 12:24 PM

    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
  41. sankarJune 28, 2021 at 1:39 PM

    nice post.sql azure training
    sql azure online training
    sql azure online course

    ReplyDelete
  42. KITS TechnologiesJuly 14, 2021 at 11:52 AM

    salesforce online courses
    hadoop online courses
    Data Science online courses
    linux online courses
    etl testing online courses
    web methods online courses
    business analyst online course
    oracle adf online course
    oracle rac online course

    ReplyDelete
  43. David FincherJanuary 24, 2022 at 5:49 PM

    Great post. Thanks for sharing such a useful blog.
    SEO Training in T Nagar
    SEO Training in Chennai

    ReplyDelete
  44. manashaMarch 29, 2022 at 2:59 PM

    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

Image
Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c This document is prepared for monitoring windows server where sql server installed.Mostly used OEM for monitoring databases. In this document we will cover agent installation with target addition into OEM 12c. We will also cover prerequisite like enabling port for communication from agent to oms server Agent Installation on windows server  As a part of installation, we require to fulfil prerequisite like connectivity between OEM server and Window server. For Port opening and communication between two servers Ports required to open : 4903 , 7799 , 3872 Following steps require doing for manually installation of Agent in Windows server. Verifying if the agent exists on OMS. To begin, open your Cloud Control and go to "Setup -> Extensibility -> Self Update". Open the "Agent Software" folder and check if the Agent Software of Windows x64 is with statu...
Read more

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

Image
SMS Alert logs ORA- errors This is something new in database administration part.Suppose DBA was out of office and got call from company manager to come to office.There is some problem in database.Generally DBA connect database and check connection possible or not then check any alert log entry.It is better if DBA and their company people got messages whenever any ORA- errors came in certain period of time. For this,I found some solution to read alert log and send sms to respective people. It is mandatory if we put database in archive log and where frequent archives generated.This is require because of the timestamp of archives used to get the start and end time of alertlogs entry. This is all done through SHELL script and on linux machine. Here it is the magical script can help to get the info of SMS by mail ans SMS. This shell designed to read alerts of last 30 minutes. #!/bin/bash #Go to bdump location cd /oracle1/oradata/pindb/bdump/ #SMS d...
Read more

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

Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server. ***What is Instant Client &benefits? As per Oracle docs, Oracle Database Instant Client Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, while using significantly less disk space than before. Even SQL*Plus can be used with Instant Client. No recompile, no hassle. ISVs and Partners   benefit greatly from packaging Instant Client along with their applications, saving customers the extra step of installing and configuring an Oracle client. Free. The same fully-featured, high-performance applications that Oracle ISVs and partners have always delivered will continue to work, untouched. Customers can try new packaged applications and Oracle client features quickly without worrying about other installations. Larger enterprises ca...
Read more