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 |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-11-17 : 03:05:32
|
| Hi, My boss asks me to create linked server between servers located in different domains and let a client from a third domain to connect to one server and read data of another server. So far as I know, domains should trust each other to let such linked servers work, while in our situation we can't let domains trust each other. Still, my boss needs online data from two servers.Now, please help me to choose a different solution, cause none of replication, mirroring, warehousing etc. let online (without delay) data. Any idea or comment is appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 03:28:36
|
| Cant you use transactional replication?http://support.microsoft.com/kb/321822 |
 |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-11-17 : 03:37:09
|
| Thanks for the reply VisakhTransactional replication, synchronizes data at the specified intervals (am I right?) so that's not acceptable for our boss. He says every time the application shall display the real data from all servers! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 03:58:39
|
| then i think you might have to use distributed transactionshttp://msdn.microsoft.com/en-us/library/ms188386.aspx |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-11-19 : 06:32:56
|
| so far as I've concluded, by distributed transactions we have the same data in both servers; am I right? |
|
|
|
|
|
|
Linked Server in different Domains