Re: Manually Replicating a Database

Kevin Bongiovanni (bong_at_fwb.gulf.com) wrote:
: I like it. Exporting the changes from the first database. Replace it
: with the second database and then updating the database with the export.
: Finally, replacing the second database with the first one. Both are in
: sync.
 

: Now, will this work.
 

: (Monthly syn)
: Total Export database one.
: At the end of the month do an increment export.
: Replace database with the second database.
: Import change data using the incremented export.
: Now, First database is updated.
: etc etc
 

: What ya think (trying my southern talk) :)
 

: Kevin
: bong_at_fwb.gulf.com

This sounds like it would work...
You might have a problem with any rows that might have been entered into both systems being duplicated after the process, and of course both sides would need to be exactly the same when you first started this scheme...

If you try this, post the results...

Randy

--

_/_/_/_/  _/     _/  _/      _/  _/_/_/  _/_/_/_/   _/_/_/    _/_/_/
_/        _/_/   _/   _/     _/    _/    _/    _/  _/    _/  _/    _/
_/_/_/    _/ _/  _/    _/   _/     _/    _/_/_/    _/        _/    _/
_/        _/  _/ _/     _/ _/      _/    _/        _/        _/    _/
_/_/_/_/  _/   _/_/      /_/     _/_/_/  _/         _/_/_/   _/_/_/
=====================================================================
    Randy DeWoolfson  -  ergo sum    :-)        envipco_at_cais.com
 or Ron Frederick     -  ergo ?      (8P
---------------------------------------------------------------------
#include <StandardDisclaimerOnOpinions>  // Null if file not found.
=====================================================================