Please HELP me its urgent? If i want to EXPORT data from
SQL server to ORACLE 11g then how can I replicate data from
SQL to ORACLE?

Answer Posted / abdul

Another Option would be do a bcp out for sql server data to
csv file, then do a sql loader script to insert into Oracle
from csv file.by this way you can even preserve timestamp

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State and explain the different types of data models?

705


How translate command is different from replace?

732


What is the difference between sharding and partitioning?

724


How do I find my oracle client driver version?

731


What is a proxy class?

726


What is java oracle used for?

760


How can I introduce multiple conditions in like operator?

724


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1923


What is tns name?

729


Explain the characteristics of oracle dba?

855


What is a trigger and what are its types?

794


How to create a temporary table in oracle?

927


Differentiate between pre-select and pre-query?

822


How to assign data of the deleted row to variables?

793


What is the difference between primary key and unique key and foreign key in oracle?

748