Unanswered: Synchronizing a live db with a reporting db.
I'm new to Informix, and wondering if there's a better way to do this.
Currently, the client has some scripts to
1) copy out a bunch of (live) tables to data files
2) drop the reporting database and recreate the table schemae
3) import the live data into the newly initialized reporting database.
I would think that there is a much better way to do this. Is there a sort of "synchronization" utility, which will make database TWO look exactly like database ONE when it's done?