Sql to oracle data transfer | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Sql to oracle data transferHello friends,want to transfer data from sql to oracle having same structure in both database.here sql means SQL Server..but data will be added every hour in sql database table and want to transfer continuosly.whenever the data is available in sql server table it should b transferred immediately.Please guide me how can i do that..
Welcome to the forums.
You have to take your time to go through the information available on books online, for instance take a look at this http://download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/OracleSSIS.docx document which talks about the process and procedures.
Also for books online download and update your local coyp from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f here.
If you want to refresh data on hourly basis best choice would be create SSIS Packages,
If you want to refresh data immediately you might need to look into repliactions or same thing can be achived by writing DML triggers on SQL tables to pupulate he Oracles tables (must need linked server)