This post is more than 5 years old
643 Posts
0
1519
Oracle 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?
zhaos2
643 Posts
0
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;
jeff_browning
256 Posts
1
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
256 Posts
0
May 11th, 2012 05:00
Works for me. Glad to be of help.