Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008

    Unanswered: Integration of SQL server with Cache DB, Informix and Oracle

    SUB: pushing data to SQL server from Informix, Oracle and Cache DB

    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.


  2. #2
    Join Date
    Jun 2004
    Take a look at SQL Server 2005 SSIS or DTS for SQL Server 2000.

    Last edited by r937; 03-23-08 at 00:45.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts