Sql to oracle data transfer | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sql to oracle data transfer

Hello 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)

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |