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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-05 : 11:01:38
|
Melvyn writes "Hi,
I have two databases. Both have same content but at different locations. I want to update the second database whenever there is an Update, Delete or an Insert in my first database. I tried using Publishing and Subscription method but the problem is it is not working. On the Publisher server it shows that the Subscription machine has not started.
In the log it shows that the subscriber machine should have per seat lincense instead of per server license. Is it true. ?
How reliable is this method of updating these two database using Publisher and subscription method?
The synchronisation should be real time.
Please let me know this as I have to use it in my project which is heavily dependend on Synchronization (I have to tackle distributed database over a city)
Thanks & Regards" |
|
|
|
|
|
SQL Server Publisher