how can i transfer data
-
how can i transfer data from sql server 2008 to oracle using script
-
how can i transfer data from sql server 2008 to oracle using script
Create a linked server in sql server pointing to the oracle database write the script to transfer the data and run it against the linked server connection
Never underestimate the power of human stupidity RAH
-
how can i transfer data from sql server 2008 to oracle using script
you can also look into Sql Server Integration Services (SSIS) if you have high data volume for better performance plus its a great tool to learn as well if you are interested in ETL and related working.
-
Create a linked server in sql server pointing to the oracle database write the script to transfer the data and run it against the linked server connection
Never underestimate the power of human stupidity RAH
I did connection with oracle using linked server . it works fine. and when i insert record from sql to oracle .it only transfer one record .i need to transfer more than one.
-
you can also look into Sql Server Integration Services (SSIS) if you have high data volume for better performance plus its a great tool to learn as well if you are interested in ETL and related working.
MY manager wants me to do using linked server
-
MY manager wants me to do using linked server
Proceed accordingly then ;) and best of luck.