Re: Table - how to sync.

You can use table subtraction between the two instances to keep development in sync with production. Running from development and assuming db link, then ....
insert into table TA
select * from TA_at_prod minus
select * from TA;

Arkzoyd wrote:

> In article <85g10t$ibh$1_at_nnrp1.deja.com>,
> Nandakumar <N.Kumar_at_rocketmail.com> wrote:
> > Are there any tools/packages in the market to sync. one table with
> the
> > same table on a different host? ie to sync. a development system
> > table with the production system's.
> >
> > Thanks
> > Nandakumar
>
> The answer to your question as you think of it is probably somewhere
> between the snapshots and the "Replication Option" which is available
> with the Entreprise Edition since Release ???.
>
> But, I imagine you don't want the changes from the dev. to be validated
> on the production node ! "Batch" is a good solution, and if you don't
> want to penalize the production node, keep a snapshot RO, from the
> table on your dev. Environment !
>
> Best Regards
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Wed Jan 12 2000 - 00:50:09 CST