Re: Informix to BRS database translates

labutis@ibm.net (Richard Labutis) wrote: > >Has anyone seen a commercial program that will automate or help the conversion from >Informix to BRS Search? We currently do it the hard way be means of 4GL programming. > >You may be asking why bother? BRS is very very fast for full text searches compared to informix. > > It's relatively easy to write a 4GL or ACE report to dump out data from Informix into a BRS database load format, so don't expect to find a product out there. The other way, BRS to Informix, that's a problem. You lose a lot of control over data entry when you move to BRS unless you get down into some 'C' programming outside of the BRS environment. That's why we're planning on moving from BRS to some other relational database in one of our applications. Data integrity far outweighs ease of search there. On the other hand, we have a heavily text oriented system which will stay in BRS.