DTS and Full-Text Catalogs

  • Hi there

    Basically ... I want to do DTS Exporting data through a wizard from one SQLServer 2000 to another. The copy method that I use is the 'Copy objects and data between SQL Server databases'.

    But I realise that everytime I do DTS over ... I need to define again a full-text indexing on one of the table in the targeted sql server.

    So ... the question is there any way that with a DTS that you can export Full-Text catalogs object to another sql server database?

    Thanks, Val

    PS.

    * Currently I have to do the a SQl Job on the targeted server that run this following query:

    exec sp_fulltext_table 'Content', 'Create', 'Cat_MAWeb', 'PK_Content'

    exec sp_fulltext_column 'Content', 'Content_Text', 'Add'

    .. to solve this issue.

  • Are you dropping the table each time?

    Andy

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply