Full Text Search - How do I best update Index - Merge Replication

Hi,
How do I best update a Full Text Index on SQL2000 sp3, for Merge Replication
(Push Subscription)?
Here is the config:
Site 1:
I have one table with one column (ntext), which I have created a full text
index.
The table updated once per day, data is never updated, always insert new
rows.
The table is Read-Only.
Everyone in Site 1 is happy... full text working good.
Site2: - Branch Office
I have created a merge replication, (push subscription on Site1):
We now have a copy of this read-only database/table in site #2.
I created a full text index on it, this is also working good.
Now after 24 hours, Site 1 gets 1000 new rows of data.
Since I have a push subscription, these new 1000 rows of data will get
pushed to site 2.
How do I automatic the full text index so it will add these new rows (column
data) to the full text index?
Once again, these are not updates, always new rows of data.
I would like to avoid using the Full Text Scheduler.
If I configured a Trigger on Site 2, how would it know when the 1000 rows
where finished inserting rows?
Thanks
Russell Mangel
Las Vegas, NV
use change tracking with update index in background on the subscriber.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Russell Mangel" <russell@.tymer.net> wrote in message
news:eDrSSZHeEHA.2384@.TK2MSFTNGP09.phx.gbl...
> Hi,
> How do I best update a Full Text Index on SQL2000 sp3, for Merge
Replication
> (Push Subscription)?
> Here is the config:
> Site 1:
> I have one table with one column (ntext), which I have created a full text
> index.
> The table updated once per day, data is never updated, always insert new
> rows.
> The table is Read-Only.
> Everyone in Site 1 is happy... full text working good.
> Site2: - Branch Office
> I have created a merge replication, (push subscription on Site1):
> We now have a copy of this read-only database/table in site #2.
> I created a full text index on it, this is also working good.
> Now after 24 hours, Site 1 gets 1000 new rows of data.
> Since I have a push subscription, these new 1000 rows of data will get
> pushed to site 2.
> How do I automatic the full text index so it will add these new rows
(column
> data) to the full text index?
> Once again, these are not updates, always new rows of data.
> I would like to avoid using the Full Text Scheduler.
> If I configured a Trigger on Site 2, how would it know when the 1000 rows
> where finished inserting rows?
> Thanks
> Russell Mangel
> Las Vegas, NV
>
>
>
|||Thanks for your reply, I will try this.
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:ub1IZWPeEHA.2908@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> use change tracking with update index in background on the subscriber.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Russell Mangel" <russell@.tymer.net> wrote in message
> news:eDrSSZHeEHA.2384@.TK2MSFTNGP09.phx.gbl...
> Replication
text[vbcol=seagreen]
> (column
rows
>

Full Text Catalog Scripting

When rebuilding a replication set it seems that the target db loses its
full-text catalog. Is there a way to script the addition of the full--tect
catalog to the target db? Thanks.
I am not sure what you mean. On SQL 2005 you need to choose to replicate
full-text indexes and ensure you have enabled your database for fulll-text
indexing. In SQL 2000 you must ensure that in your snapshot options you
delete all data in the table should the table already exist on the
subscriber.
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
"DC_SQL_GUY" <DCSQLGUY@.discussions.microsoft.com> wrote in message
news:BA030F09-4D46-4999-853A-27A0DE9471B1@.microsoft.com...
> When rebuilding a replication set it seems that the target db loses its
> full-text catalog. Is there a way to script the addition of the full--tect
> catalog to the target db? Thanks.
|||Hilary,
I drop all of the tables on the target before recreating the replication
set. Thanks for the assistance.
Sincerely,
Todd
"Hilary Cotter" wrote:

> I am not sure what you mean. On SQL 2005 you need to choose to replicate
> full-text indexes and ensure you have enabled your database for fulll-text
> indexing. In SQL 2000 you must ensure that in your snapshot options you
> delete all data in the table should the table already exist on the
> subscriber.
> --
> 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
>
> "DC_SQL_GUY" <DCSQLGUY@.discussions.microsoft.com> wrote in message
> news:BA030F09-4D46-4999-853A-27A0DE9471B1@.microsoft.com...
>
>

Full Replication

I am about to replicate my sql databases. I have two servers, and two SAN units. I have one front end server direct attacted to each SAN unit. I want to use replication. Using the SQL 2000 replication software, will both of my databases have eactly th
e same data? I want to make an exact image for disaster recovery purposes. Will SQL2000 builtin replication work for me or do I have to purchase a third party software?
Thank You,
Joe
you can replicate all user data using merge replication, but only tables
with primary keys with transactional replication.
"Joe" <anonymous@.discussions.microsoft.com> wrote in message
news:65B98550-D089-485F-8B87-EDFB7C645AED@.microsoft.com...
> I am about to replicate my sql databases. I have two servers, and two SAN
units. I have one front end server direct attacted to each SAN unit. I
want to use replication. Using the SQL 2000 replication software, will both
of my databases have eactly the same data? I want to make an exact image
for disaster recovery purposes. Will SQL2000 builtin replication work for
me or do I have to purchase a third party software?
> Thank You,
> Joe