[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

SQR as a database migration tool?



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?

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.

Has anyone any experience or ideas in this matter?


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