I'm wrestling with what would seem like it should have been a pretty simple issue involving Full-Text Search & Replication on SQL 2k.
The system I'm working with does daily data loads into a staging database, which is then replicated over to a production system. One of the tables on the production system utilizes Full-Text indexing for some functionality.
I would like to be able to populate the FTS in the staging database prior to replicating it over to the production database in order to reduce downtime. Currently, it takes approximately 6 hours to populate the FT index.
That being said, SQL 2K doesn't support replication of full-text indexes like SQL 2k5 does, so right now I'm left to believe that it might not be possible, outside of some funky registry hacks as described in
Q240867 on Microsoft's site.
Has anybody had any luck doing anything like this? These two databases are on the same server, I have a hard time believing that the only solution to this particular problem is the MS solution... It just seems very hacky to me.
I'm not neccesarily tied to replication for moving the data over from the staging database to the production database, I just want to minimize downtime on this system.
Any ideas would be greatly appreciated!