Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Posts
    1

    Unanswered: How to restor in Ms-Server?

    I have a database on Oracle .Now I want to work on MS-Server 2008 .I want oracle database restore to ms-server database ,but how to?Give me some syntax ? Thanks for the help.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Neither product (Oracle and Microsoft SQL Server) will restore a backup made by the other. With the exception of MySQL (which takes the approach of storing backups as executable SQL statements) I don't know of any database that makes a backup that can be restored by a different database engine/product.

    You can use SSMA 2008 for Oracle V4.0 or SQL Server's SSIS to help you convert your Oracle database to SQL Server

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

  3. #3
    Join Date
    Jan 2009
    Location
    United Kingdom
    Posts
    77
    Depending on the size and complexity of the database objects ,you could attempt to migrate via some customised mapping.
    There is also a tool - offered by MS - which assists in migrating called SSMA

Posting Permissions

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