I am using Oracle SQL Developer and I have ten tables. Now I want to move all 10 tables from Oracle into a SQL Server 2008 R2 database. Is there any easy solution for this task?
Sql-server – How to Move All tables from one Database into Different Database
oracleoracle-sql-developersql serversql-server-2008-r2
Related Question
- Insert into table from a query to a linked database hangs
- Applying data changes from one database to another
- SQL Server – How to Pull Data from Identical Tables in Different Databases
- Oracle SQL Developer – Database Diff for Tables & Constraints
- Oracle SQL – How to Grant User Permissions to SELECT from a Table
- Oracle DB – How to Export Only Table Data from Given Schemas
Best Answer
There are a lot of ways to do this one that go beyond what I listed, but here's a start.
1) You could try the SQL Server Migration Assistant for Oracle. It's free and usually works well for me for smaller or medium sized datasets.
http://www.microsoft.com/en-us/download/details.aspx?id=28766
2) Create a SSIS package.
3) You could create a linked server in SQL and then select * from Oracle into SQL table (messy and probably not a good idea).
http://support.microsoft.com/kb/280106
4) Export to flat files and import into SQL. Again, a ton of caveats with this one.