Groups | Blog | Home
all groups > sql server replication > march 2007 >

sql server replication : SQL Publications


Andrei Zakharov
3/20/2007 12:00:00 AM
Hi,

There are 18 Transactional Publications, one for every
subscriber. In these publications there are certain tables where the data
practically do not change. The data in these publications is transferred
to all subscribers identically.
There is one Merge publication, with 18 subscribers. Its
tables do not cross with those in Transactional Publications, and its
data is changed regularly and is transferred to all subscribers
individually separated. Selection of the data for each subscriber is
regulated by many rules (which are adjusted by publication properties).

1) Is it possible to change structure of the tables in all above mentioned
databases and to correct data selection rules of the Merge publication
without re-initializing subscribers?

2) Why is text in Russian displayed incorrectly in all the stored
procedures after the post-snapshot script has been executed at the
subscriber side (although it is seen correctly in the post-snapshot
script itself), and, how can it be fixed?

--
Andrei.

Hilary Cotter
3/20/2007 12:00:00 AM
1) No you need to reinitialize.
2) can you give me an example of what you are talking about?

BTW-I would probably have a single merge and transactional publication for
logistical reasons.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

AddThis Social Bookmark Button