Click here to Skip to main content
13,145,774 members (56,075 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
Can we export Oracle database to Sql Server? If yes HOw?
Posted 25-Sep-12 18:39pm
sp1786673
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Try the migration tool[^] supplied by Microsoft.
  Permalink  

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


Advertise | Privacy |
Web03 | 2.8.170915.1 | Last Updated 26 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100