Sunday, February 19, 2012

Changing ftcatid on the fly?

Hi all
Quick question, I have a set of full text catalog files that we would
like to use to re-create a set of catalogs on a new build database, as
part of a build script. I have copied a set of files to a devstore on
out SAN with the intention of moving these to each local file system
before creating the catalogs.
I have the script and the bcp's writtten to create and populate both
the CRUD and the Search Databases. The search DB is the one with the FT
enabled.
My plan is to script the catalogs, then move the files to the local
file system, initially i wanted to create the new files with a dynamic
rename ( to follow the SQLxxxxx(dbid)yyyyy(ftcatid) naming convention)
however as all the hash files use the same name I am thinking it would
be easier to align the dbid and ftcatid to the ones specified on the
devstore files,
So this gives me a hardcoded dbid of 7, which i can recreate in the
build script by attaching and detaching dummy db's till i get the dbid
i need.
My question (finally!) is can i create the catalogs on the new machine,
then edit the ftcatid values in the sysfulltextcatalogs table to give
the catalkogs the desired ftcatid's (which would be 5,6,7)
Is this going to cause me a massive headache, or is there a better way
to create A number of prepoulated FT catalogs from a 'master' set?
regards
Barri Martin
SQL Bod - DWP.gov.uk
You can do this, but I would consult this article for a complete guide on
how to do it.
http://support.microsoft.com/kb/240867/
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
<barri_j_martin@.yahoo.co.uk> wrote in message
news:1159372232.664003.16300@.i42g2000cwa.googlegro ups.com...
> Hi all
> Quick question, I have a set of full text catalog files that we would
> like to use to re-create a set of catalogs on a new build database, as
> part of a build script. I have copied a set of files to a devstore on
> out SAN with the intention of moving these to each local file system
> before creating the catalogs.
> I have the script and the bcp's writtten to create and populate both
> the CRUD and the Search Databases. The search DB is the one with the FT
> enabled.
> My plan is to script the catalogs, then move the files to the local
> file system, initially i wanted to create the new files with a dynamic
> rename ( to follow the SQLxxxxx(dbid)yyyyy(ftcatid) naming convention)
> however as all the hash files use the same name I am thinking it would
> be easier to align the dbid and ftcatid to the ones specified on the
> devstore files,
> So this gives me a hardcoded dbid of 7, which i can recreate in the
> build script by attaching and detaching dummy db's till i get the dbid
> i need.
> My question (finally!) is can i create the catalogs on the new machine,
> then edit the ftcatid values in the sysfulltextcatalogs table to give
> the catalkogs the desired ftcatid's (which would be 5,6,7)
> Is this going to cause me a massive headache, or is there a better way
> to create A number of prepoulated FT catalogs from a 'master' set?
> regards
> Barri Martin
> SQL Bod - DWP.gov.uk
>

No comments:

Post a Comment