Re: Question re basic replication

John Leslie wrote:
> Why do I want to initiate the refresh from the master site?
>
> Bascically because there will be a person at the master site who is
> responsible for the data in the master tables. They would like to be
> able to update the master tables and test the application before
> explicitly releasing the updated tables to the snapshot sites.
>
> John

And then what: data is wrong; delete it, try again, and again, and again...
Sure a fine way to fill up your snapshot log tables... add a record, delete it, add it, delete it, etc. etc. All that will get replicated, of course - you *do* want your databases to be consistent, don't you?

To me, it looks like you don't want replication. You want your test instances copied to other locations.

Then do so - the closest your come to replication, is full refreshes (basically: truncate, and update table select * from remote table)

And yes - this can be done on the remote side/sites; just create refresh packages/procedures, and call these from the master site.

But I fail to see what this has to do with replication as I know it.

-- 
Regards,
Frank van Bortel