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?

Answers were Sorted based on User's Feedback



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

Answer / shallu

You can use SwisSql utility to do that.

Is This Answer Correct ?    1 Yes 1 No

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

Answer / 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

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

Answer / amit

Thanks Shallu if possible will you please send me some link
on SwisSql utility.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle General Interview Questions

what are the advantages of running a database in archive log mode?

0 Answers  


How to increment dates by 1 in oracle?

0 Answers  


How to count groups returned with the group by clause in oracle?

0 Answers  


What is a directory object?

0 Answers  


what are Triggers?

7 Answers   TCS,






What is an Extent ?

3 Answers  


How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

0 Answers   Wipro,


How to create a table interactively?

0 Answers  


how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

2 Answers   TCS,


How to select an oracle system id (sid)?

0 Answers  


how to tune oracle sql queries pls tell me step by step. urgent pls

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)