taking database backup with data in oracle and restore it in sql server?

Question

I want to take the table structure with data from oracle and restore it in sql server ? is it possible ?

Answer 1

No, but you can use Import Wizard in SQL Server to import oracle database.

Answer 2

you can use attach database option from SQL Server Enterprise Manager



i.e

SQL Server Enterprise Manager

Console Root

SQL Server Group

Server(local or whatever name you have)

Databases



right click databse and then All Tasks then Attach Database

Answer 3

This many times turns right into a very political argument, such as the question "which OS is greater useful, residing house windows or UNIX/Linux?". in line with quite a few years of private database journey and bias, I vote for Oracle, the comparable way I vote for UNIX/Linux for any style of severe database and utility progression.