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 |
|
snufse
Constraint Violating Yak Guru
469 Posts |
 Posted - 2007-09-25 : 10:44:33
|
| We have configured a linked server pointing at a db2 data source and created views. This works fine. Now, my question: We also have a db2 backup machine which we utlilize from time to time (when hurricane threatens Florida) and do a roll-over. The backup machine now becomes the production machine. All the linked servers and views are pointing to the db2 production machine and in case of roll over we have to modify or recreate linked servers and views to point to the db2 backup machine. Is there a way to have linked server point at a generic db2 system and behind the scene have the actual data source source? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-25 : 23:31:29
|
| If you use odbc provider, just change db2 server name in odbc dsn. |
 |
|
|
|
|
|
Linked Server Set Up