sql server full text search: Hiya All,

We run a Developmnet-> Staging -> Production build environment here.
We use Red Gate SQL Compare (a REALLY great bit of kit btw) to move
between the tiers.

We are having a bit of a problem now that we have some fulltext indexes
defined. Reason being is that Development and Staging are on the same
server. So I don't think we can have two databases using exectly the
same FTS index file name on the same machine. This stops us fropm fully
syncing our databases.

So at the moment we have a *_Dev_TableName_FTS file and a
*_Staging_TableName_FTS file. But this means that the table definitions
in the respective DBs directly reference the FTS catalog files and thus
we can't easily sync those tables using the tool.

Anyone got any ideas?

Cheers
Chris

Chris,
Well, my first thought is to have you call Red Gate SQL Compare support and
request that their product support SQL Full Text Search and external FT
Catalogs as both are fully supported by Microsoft and SQL Server, so why not
support from a 3rd party software product? - Inquiring Minds want to Know
why they don't support SQL FTS!

My second thought, is that I'm not at all surprised that they don't support
SQL FTS and FT Catalog comparisons between SQL Server databases as the FT
Catalogs are external to SQL Server... That said, the best approach is to
modify some of the procedures to your needs from KB article 240867 (Q240867)
"INF: How to Move, Copy, and Backup Full-Text Catalog Folders and Files" at:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867

While you may never be able to use the same FT Catalogs as the physical FT
Catalog name includes the dbid as well as the ftcid from
sysfulltextcatalogs, you can use the SQL code from the generate the metadata
necessary to create similar FT Catalogs for both tables in their respective
databases.

Hope that helps!
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/



[quoted text, click to view]