Integration of SQL server with Cache DB, Informix and Oracle

• vsrprasad16

  Newbie

  Points: 7

  More actions

  March 12, 2008 at 7:48 am

  #124439

  we r doing some application and SQL server as backend DB Server. this sql server has to be updated continiously 24*7 with data from 3 external sources Cache DB, Iformix and Oracle DB servers. How to handle this in such away that all changes at 3 external sources to be updated to SQL server and this data will use by our application at frondend.

  we though of ODBC., but ODBC is very very slow. It should lke Shadowing.

  How to handle this?. any help will greatly appreciated.

  Thanks in advance.

  Prasad

  vsrprasad16@gmail.com

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  March 12, 2008 at 11:54 am

  #788723

  You can setup pull replication from Oracle to SQL Server in 2005.

  I do not know anything about the others.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]