SQL 2005 - Full Text Index and Merge Replication -- sql server replication

Venketash (Pat) Ramadass
6/13/2006 12:00:00 AM

Hi there,

We are using merge replication over HTTPS between a SQL 2005 Standard
publisher db and SQL Express 2005 with Advanced Services subscribers. The
SQL Express instances have been installed with the following command line...

SQLEXPR_ADV.EXE /qb INSTANCENAME=<instancename>
ADDLOCAL=SQL_Engine,SQL_Replication,SQL_FullText SECURITYMODE=SQL
SAPWD=<pwd>

....which I believe should install all the full text functionality required.
Then, on the publisher, we have set all the table articles required "Copy
full text indexes" to true. A new snapshot was generated and all
subscriptions are set to be reinitialised when they next synch.

The problem is that the full text index is not being pulled down to the
subcribers during synchronisation. What are we missing?

I have confirmed that the full text index functionality is install on the
SQL Express instances as there is a setting under the database's
Proprties/Files section called "Use Full Text indexing" which is set to
true.

I am guessing it is something small we have overlooked, that or this just
isn't supposed to be done. We are already behind on deploying this so any
help would be much appreciated.

Kind regards,

-Pat Ramadass

Venketash (Pat) Ramadass
6/14/2006 12:00:00 AM

Hello again,

Has no one else had these issues with merge replication? It sounds like
similar problems have occurred with transactional as per..

http://www.replicationanswers.com/FTI2005.asp

....should I be trying the same? From that article it sounds like those
issues do not affect merge replication.

Thanks,

-Pat Ramadass

[quoted text, click to view]

sql server replication : SQL 2005 - Full Text Index and Merge Replication