Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transferring Full-Text Indexes
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00684263
Message ID:
00687658
Vues:
31
Eric,

Thanks for the reply...

The only thing I found is the following article:
Knowledge Base Article Q240867, "INF: How to Move, Copy and Backup SQL 7.0 Full-Text Catalog Folders and Files."
LINK: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q240867

The article discusses the fact that the ID's for the tables and indexes must match between databases for the DTS transfer to work. I will probably continue to look into this so I can get it done correctly.

If you find out more please advise....

Thanks,
Mike



>Mike,
>
>I had this same problem. I ended up deleting the index on my development server, transfering the table, and then recreating the index on both, my development and production. Im curious if there is a better solution.
>
>
>>Hi,
>>
>>I have performed "Import Data - Transfer Objects" using DTS of a table and its full-text index from one database to another. I noticed in the DTS window there is an option to select "Transfer full-text indexes" which is checked by default. While the table transfers fine the full-text index does not transfer.
>>
>>Is there something I am missing in this picture?
>>
>>Thanks for any help...
>>Mike
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform