Re: snapshor replication

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Mon, 03 Sep 2001 14:45:45 -0700
Message-ID: <3B93FA09.16AE3853@attws.com>

Comments embedded below.

Daniel A. Morgan

May wrote:

> I have 2 problems when I use snapshot replication.
>
> 1) The 2 servers are different in time; one is in Beijing,
> the other in New York. So even if we insert a record at the
> same time in two databases, we can not recognize the order of the
> insert correctly.

You need to pick a single timezone for use on all servers for the data. Most people use GMT.

> 2) the table will be replicated could not exist on snapshot site.
> it is a hard problem for us,since we are a 24 x 7 database,It's not
> acceptable to drop
> the table at the snapshot site even for a short time.
> how can we solve it?

Do not understand fully what you are asking. Please clarify. Received on Mon Sep 03 2001 - 16:45:45 CDT