I have two databases, one is live on the internet and one for testing. I want
to copy all the database structure and content from the live machine to the
test machine frequently, to have a mirror. So I created a DTS package that
copies all SQL objects into the test DB.
The problem is that after the copy process the full text catalogue ist
destroyed. It is still shown under catalogues, but the connection to the
table is gone. So I don't have an active fulltext-index on the test machine.
I tried all options in the properties dialogue, including the option "copy
fulltext index" a.s.o.
Has anybody the same experience and a smart solution for this?