We have a few AREV 3.12 applications. Some of the same applications are spread accross different servers. The servers hold different uses of the applications, such as our Live appplications, Testing, Develop and one server for our DBA's to use for testing user problems or updates before they go to Live. Currently we are talking about refreshing data accross some of the different applications on different servers. I have it in my mind that there can be some pit falls related to indexing but I can't seem to find any mention of it in this On-Line Discussion area. Can anyone point me in the right direction?

What I seem to remember is that if you copy a file between applications that you need to remove all the indexes on the target file and rebuild them from scratch. This is because when the indexes are first built, they pull in the application's label. That some how points back to the orignial application. So if you update the target file without first removing indexes the in fact the original file's indexes get updated because of some pointer.

Is it that copying the data files between applications is alright, it's just not advisable to copy the associated index file as well? That the data files are copied and then the indexes are rebuilt in the target application and then there shouldn't be any problems?

Again, if you could point me in the right direction that would be much appreciated.

Thanks,

Michael Slack

Very interesting question Micheal,

if I was going between my test and production system I would just normally copy the REV files across, but In fact the two systems have

the same APPLICATION name. So this is something I was not aware of till I read your message.

For your needs I would advice copying the dictionary first and then

indexing the blank files on the system you are copying to. This will update the index pointers for you as if you are creating a new file.

Then use a transfer file to move the data to, and use the copyrow command from the transfer file to the new file. After that the auto

indexing will set everything up for you.

Hope this helps, it will take longer than an actual dos file copy, but

if what you say is correct about the APPLICATION name in indexes then I dont know of any other way it will work.

View this thread on the forum...