Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vsrprasad16
Starting Member
1 Post |
 Posted - 2008-03-12 : 10:42:10
|
| 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. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-12 : 11:37:05
|
| Create as linked servers, not sure, but you will need drivers for all the other databases. As for where to get them, I am not entirely sure. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Integration of SQL server with Cache DB, Informix