April 29, 2005 at 9:46 am
i have a dev sql server and a live sql server. The live server needs to have full text on three tables.
i want to replicate the dev db to live but this causes problems with the live text catalogs
Can i replicate the catalogs themselves.
Seem like what i have to do is some sort of tricky identity insert on the three tables with catalogs then rebuild the catalogs (at leasts incrementaly based on the new data)
this is seems like a lot of work and as a lazy person that seems just about intolerable.
is this the best way?
Could i script triggers to run after i replicate (just once a week) to set identiy columns, create and populate the catalog?
this seems like even more work.
any ideas?
andrew reale
minderbinder.net
April 29, 2005 at 1:08 pm
>>> i want to replicate the dev db to live but this causes problems with the live text catalogs <<<
What Problems are you seeing ?
* Noel
May 2, 2005 at 9:18 am
When i replicate the catlogs are destroyed.
andrew reale
minderbinder.net
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply