all groups > sql server replication > january 2005 >
You're in the

sql server replication

group:

updating publicatgion DB base on subscription DB changes


Re: updating publicatgion DB base on subscription DB changes Hilary Cotter
1/30/2005 7:27:38 AM
sql server replication:
Use immediate updating if you have a reliable link, or queued updating
otherwise.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
[quoted text, click to view]

updating publicatgion DB base on subscription DB changes Nick
1/31/2005 6:20:11 AM
updating publicatgion DB base on subscription DB changes, is that possible
to do?

and how can we make sure the orders?



cheers

Re: updating publicatgion DB base on subscription DB changes Nick
1/31/2005 9:38:28 AM
Hi Hilary:

I think i have a reliable link , because both publication and subscription
DB are in the same SQL server.

Could you explain a bit detail about how to use immediate updating in this
case?

Cheers
[quoted text, click to view]

Re: updating publicatgion DB base on subscription DB changes Nick
1/31/2005 10:19:58 AM
By the way. in this case , which replication is suitable to use?

Cheers

nick
[quoted text, click to view]

Re: updating publicatgion DB base on subscription DB changes Nick
1/31/2005 3:51:33 PM
another question is that can i achieve this by using DTS instead of
replicaton?

which one performance is faster?


Cheers

nick


[quoted text, click to view]

AddThis Social Bookmark Button