Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL Oracle Server
Can we export Oracle database to Sql Server? If yes HOw?
Posted 25-Sep-12 18:39pm
sp1786668
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
0 Sergey Alexandrovich Kryukov 480
1 mhegazy94 460
2 Kornfeld Eliyahu Peter 315
3 Ravi Bhavnani 240
4 Shemeemsha RA 185
0 Sergey Alexandrovich Kryukov 6,890
1 OriginalGriff 6,761
2 CPallini 5,350
3 George Jonsson 3,609
4 Gihan Liyanage 2,797


Advertise | Privacy | Mobile
Web01 | 2.8.140922.1 | Last Updated 26 Sep 2012
Copyright © CodeProject, 1999-2014
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