how snapshot replication works?

[yuhong wu]

I have a snapshot replication between sqlserver 2k and sybase,the
replication include serveral tables,my questions is:
when replication happens,did sqlserver drop all tables included in the
replication and rebuilt the tables and datas in sybase all at same time ,or
delete one table and the rows of the table,then rebuilt the table and rows
in sybase and then another table orderly?

thanks in advance!

[Hilary Cotter]

IIRC it is a single table at a time.
"yuhong wu" <yuhon...@hotmail.com> wrote in message
news:%23ZEpgKw...@TK2MSFTNGP09.phx.gbl...

[Andrew Carter [MS]]

It depends on your schema options for you article. You can determine the
behavior you want. Snapshot replication can drop the table and recreate or
it can simply attempt to append data to an existing table. Typically,
dropping or truncating the table is desirable since you want to have an
exact copy of the SQL Server data on your Sybase server. Note that the very
notion of snapshot is to get an exact copy from a point in time. This is
different than transactional replication in which you want the incremental
changes.

--
Andrew Carter
Software Design Engineer - SQL Server Replication
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.