SQL Server Performance

Sql to oracle data transfer

Discussion in 'SQL Server 2005 Integration Services' started by rahulpatel112, Jan 17, 2011.

  1. rahulpatel112 New Member

    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..
  2. satya Moderator

  3. RamJaddu Member

    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)

Share This Page