Re: Replication question

76434.1353_at_compuserve.com wrote:

> I have to replicate the same table "A" from 5 different servers to a
> central server 6 . In short replicate 5x table "A" to 5x seperate
> tables "A " on server 6.
>
> What is the best option to approach this?
>
> -Export - Import is not efficient (besides that I need to refresh the
> central tables o server 6 every hour)
>
> - I was thinking about creating a snapshot from the 5 server to
> central server 6 or has somebody a better idea for me?
>
> Questions about Snapshots.
> Has the schema owner on the master server to be same schema owner on
> the target server?
> - Table A has the same name ("A") in every server. Can the snapshot
> send data to a different table name on the target server? I need 5
> separete tables in the target (central) server.
>
> Thanks
>
>
>

How often?
How close to real time?
How much data?
How mission critical?

Daniel Morgan Received on Sun Mar 09 2003 - 14:37:54 CST