Hi all,
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?

Cheers!
-pet

No "syncho" utility in informix.....or Oracle or DB2. If you want both databases to be in sync.....at all times, use replication (ER).

Well, what they want is a "snapshot" of a selection of tables (about twenty tables) at each month-end that they play with and run reports on.

is unloading and reloading the only way to do that (apart from full-time hardcore replication)