Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2012
    Posts
    5

    Unanswered: Migration from Oracle to MS SQL

    Hi!
    I've been lurking in this forum and enjoy it.
    So I have a requirement to migrate a 14 year old oracle production db. I am wondering what is the best way to do the migration.

    Your suggestions and idea about it is very much appreciated.
    Thanks a lot.

  2. #2
    Join Date
    Oct 2012
    Posts
    2

    how to execute the remote oracle stored procedure from ms sql

    hi friends,

    please help , how to execute the remote oracle stored procedure from ms sql , whereas the stored procedure has input & output parameter

    Thanks in advance

  3. #3
    Join Date
    Aug 2008
    Posts
    147
    Microsoft offer a free tool for migration from Oracle to SQL Server - Free Microsoft SQL Server Database Migration Assistant
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  4. #4
    Join Date
    Sep 2012
    Posts
    5
    Thanks a lot JackVamvas!
    I will surely check it out and see if it fits my requirements.

  5. #5
    Join Date
    Aug 2008
    Posts
    147
    Just out of interest - SSIS and Oracle .Net Provider , I've found to be more reliable than OLE DB driver from MS\Oracle
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  6. #6
    Join Date
    Jan 2002
    Location
    Czech Republic
    Posts
    14
    DBConvert for MS SQL and Oracle is able to convert table structure, data and views

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by dmsoft View Post
    DBConvert for MS SQL and Oracle is able to convert table structure, data and views
    It might well be a great choice for people who want a more expensive, less capable, third party tool.

    I have trouble finding customers like that.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  8. #8
    Join Date
    Sep 2012
    Posts
    5
    Thanks to your share mates!
    Last week I was reading my resources to make a test run of Microsoft migration tool but due to some urgency I have put this task on side for the moment.
    Hopefully I can share once I've tried it.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •