Fog Creek Software
Discussion Board




Upgraded SQL Server from MSDE to FTS-capable

I've upgraded my server to a machine with SQL Server 2000. The previous machine had only MSDE (no full-text search).

I've migrated the database to the new machine as suggested in a KB article but the full-text search settings aren't there (because the original database didn't have full-text search capability).

How do I enable full-text search? I've seen a few FogBugz KB articles on viewing the properties, but nothing that tells me how to manually set up the FTS catalogs.

Craig Eddy
Thursday, April 29, 2004

Check out step 6 and below at this article:
http://www.fogcreek.com/FogBUGZ/KB/dbsetup/ImportingSQL2000.html

You may have to manually create the FogBugz_FTE job (just a job that repopulates the full text index nightly or however often you like)

Michael H. Pryor
Fog Creek Software
Thursday, April 29, 2004

Thanks! I didn't look at that article. :(

Perhaps the FTS info in there should be added to http://www.fogcreek.com/FogBUGZ/KB/howto/MoveFogBUGZ.html?

Thanks again, I'm off to enjoy my lemonade!

Craig Eddy
Thursday, April 29, 2004

The new FTS article:

http://www.fogcreek.com/FogBUGZ/KB/dbsetup/FullTextSearch.html

Dmitri
Fog Creek Software
Thursday, July 22, 2004

*  Recent Topics

*  Fog Creek Home