>Well, just copying all the tables with APPEND FROM is safe, and should be fast enough for a small system.
>
>Suggestion: Temporarily disabling RI will make the update much, much faster - perhaps by a factor of 10. For this, you do need an alternative RI technology, such as Tax RI or AMRI.

Or re-inventing the wheel, since I already wrote an RI builder for my former job based on Doug Hennig's NewRI, but I don't have this code now...