Re: Sync two DBs across firewall

The answer is dependent on how frequently you need to do it. The firewall isn't really an issue. If it's a infrequent occurrence, it's not worth setting up replication to handle it. Just export, ftp, import instead. Alternatively use insert as select where the rows don't exist, or create table as select or copy if they make more sense.

HTH. Pete

S S Wan wrote:

> Hello all,
>
> What is the better way to sync. two databases across firewall?
>
> FTP? SQL*Net/Replication? What about the security risk of
> opening a SQL*Net port in firewall? And how about the
> random client ports problem?
>
> Regards,
> SS

Received on Thu Dec 16 1999 - 10:33:38 CST