Anyone used sql relay with rt

RT Users
1

Hi;
Anyone using sql relay with mssql5 ??
I am looking into using it to redirect Content like searches to a myism
copy of the database with full text indexing ??
ideas / thoughts

Roy

2

Hi;
Anyone using sql relay with mssql5 ??
I am looking into using it to redirect Content like searches to a myism
copy of the database with full text indexing ??
ideas / thoughts

Roy

Roy,

If you are not required to use MSSQL as the DB backend, you might
consider using PostgreSQL with full text index support. It is a
contrib module called tsearch2 which is installed by default on
the Windows version, I think. This would avoid having to doing
the DB hokey-pokey just to use FTI.

Ken

3

Sorry … I meant Mysql not Mssql
Roy

Kenneth Marshall wrote:> On Thu, Mar 22, 2007 at 12:02:19PM +0000, Roy El-Hames wrote:

Hi;
Anyone using sql relay with mssql5 ??
I am looking into using it to redirect Content like searches to a myism
copy of the database with full text indexing ??
ideas / thoughts

Roy

Roy,

If you are not required to use MSSQL as the DB backend, you might
consider using PostgreSQL with full text index support. It is a
contrib module called tsearch2 which is installed by default on
the Windows version, I think. This would avoid having to doing
the DB hokey-pokey just to use FTI.

Ken