Solved!
Go to SolutionOracle Table Migration to SQL Server
In case I have an Oracle 11g and a SQL Server 2005 installed, and I have some tables need to be migrated from Oracle DB to SQL DB. Are there any reasonable ways to move Oralce tables to SQL server on a regular basis?
jeff_browning
2 Intern
•
256 Posts
1070
1
Posted May 10th, 2012 04:00
In this case, install Oracle Database Heterogeneous Services and use Database Links to move your tables from Oracle to SQL Server using the CREATE TABLE AS SELECT clause.
jeff_browning
2 Intern
•
256 Posts
1070
0
Posted May 11th, 2012 05:00
Works for me. Glad to be of help.
zhaos2
2 Intern
•
643 Posts
1070
0
Posted May 11th, 2012 00:00
Thanks Jeff for your very helpful document sharing!
From research of the above document, seems 'create table as select' clause is used to copy data from Non-Oracle DB to Oracle DB? To copy from Oracle to non-Oracle, we can use the below SQL Plus command:
COPY FROM username/password@db_name -
INSERT destination_table -
USING query;