Re: SQR as a database migration tool?

[Bob Helm <Bob.Helm@MEDIWARE.COM>]

        I sent this once but it never showed up so I'm sending it again,
slightly changed.

        Basically, we need to copy client Informix databases. Current
utility options to do this can take upwards of several hours and/or require
clients to be off the database. Most of our clients are pharmacies, some 24
hours, and so the lockout is unacceptable.

> I assume that SQR can be used to migrate the info from one database to
> another. Is this correct?
> More importantly, what kind of lock would have to occur for this to
> happen? Would users of the database have to get off before the migration
> can take place?
>
        In short:
        Can SQR maintain a connection to 2 databases at the same time?
        Will the database need to be locked for a secure migration of data?


> Thanks a tonne for any help,
> B
> The Programmer formerly known as Bob
> Mediware Information Systems Inc.
> (913) 307-1045
> Bob.Helm@Mediware.com
>
>
>
>
>