Hi DBA's
I am in the situation to move some important tables from oracle8i to
MS SQL2000 Server, is there anyway to export the tables from oracle to sql directly.
Please help in this.
Printable View
Hi DBA's
I am in the situation to move some important tables from oracle8i to
MS SQL2000 Server, is there anyway to export the tables from oracle to sql directly.
Please help in this.
You can use Data Transfomration Service of MS SQL Sever. Or use the flat files to transfer data.
Hi Sanjay,
What kind of flat file that you mentioned? How to generate to flat file?
Thanks & regards,
GS
I meant getting the data into flat files like comma saperated, using SQL*Plus and then load them into MS SQL Sevrer.