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 |
|
Incognito
Starting Member
49 Posts |
 Posted - 2001-10-01 : 07:38:47
|
| Hello,I asked earlier how to solve my problem and it seems Transactional Replication is the best solution. There is one more problem which I cannot solve:There is a server and a client. They are both online and they do the same(controlling some industrial processes). They get their information from a database. We can say that the server is the first choice, but if the user decides to use the client then the DB of the client has to be the same as the server. I used replication for this and it worked. But when the user do some changes on the client DB, the DB of the server has to be the same as the client. So they have to send information to each other when a change is made in one of them. Replication works here no more(error: it cannot drop the "servers table etc.").Mys question is next: How can I send information to the client when a change is made on the server and otherwise to the server when a change is made on the client.Thnx for your help,Incognito |
|
|
|
|
|
Transactional Replication (Server - Client)