Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Unanswered: Synchronizing a live db with a reporting db.

    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

  2. #2
    Join Date
    Aug 2003
    Posts
    68
    No "syncho" utility in informix.....or Oracle or DB2. If you want both databases to be in sync.....at all times, use replication (ER).

  3. #3
    Join Date
    Dec 2003
    Posts
    5
    Originally posted by tmullins
    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •