Hi there. I am writing a procedure to perform particular table data backups and another procedure for the restores. So I would use the EXPORT and IMPORT ABL commands to and from files. But what about the indexes? No worries?
Indices are not exported, per say. They are rebuilt when you recreate the records or, if you have the indexes deactivated during the load for speed, during the idxbuild which you run afterwards to activated the indexes.
p.s., YMMV on which approach is faster.
Presumably you are taking care to insure there are no relational integrity issues related to this process, i.e., references in exported data to records that may not be there when you reload.
Yes thanks Thomas.