Click here to Skip to main content
15,884,388 members
Search within:


Can we export Oracle database to Sql Server? If yes HOw?
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
Oracle
server
Can we export Oracle database to Sql Server? If yes HOw?
Posted
Add a Solution

2 solutions

As I know Oracle or Sql Server do not support Export Import of Data from each other. You have to migrate the Oracle Data to SQL Server.

You can use SQL Server SSIS Feature to do it.
Alternatively you can export Oracle Data to CSV files and Import that in SQL. But you have to Convert & Create Schema Object manually.
 
Share this answer
 
Posted
Try the migration tool[^] supplied by Microsoft.
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Convert oracle procedure to SQL server procedure and give SQL server procedure?
connection between Oracle and SQL Server
Convert Oracle database to Sql Server
When we export data from local server to remote server in sql server?
developpement questions: oracle,sql server etc.
how to Migrating Oracle Databases to SQL Server.
Which database is best Sybase, SQL Server, Oracle
Can we use C-programming Language to develop a project and connect it to the Oracle 10g or My Sql 2005 database?
Export SQL Server Data into Excel
Export Oracle database

Advertise
Privacy
Cookies
Terms of Use
Last Updated 26 Sep 2012
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web02 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900