I'm currently using merge replication that is not syncing the data when
applying the snapshot.
When applying the snapshot, the only bcp files transfered are
msmerge_contents.bcp, msmerge_genhistory.bcp, sysmergesubsetfilters.bcp
and msmerge_tombstone.bcp.
The problem is that the snapshot agent generates bcp files for all of
my tables. I will never use these and delete them as soon as they are
generated.
Does any know if it's possible to have the snapshot agent only copy the
merge tables and not the user tables but still generate the other
metadata scripts?
Thank you,
seanbell68@.gmail.com
I'm confused by what you are doing and why. For a no-sync subscription these
files must be generated and applied on the subscriber. Failure to do this or
emptying some of these file will guarantee your merge replication solution
will not work.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<seanbell68@.gmail.com> wrote in message
news:1121205750.708059.309200@.g44g2000cwa.googlegr oups.com...
> I'm currently using merge replication that is not syncing the data when
> applying the snapshot.
> When applying the snapshot, the only bcp files transfered are
> msmerge_contents.bcp, msmerge_genhistory.bcp, sysmergesubsetfilters.bcp
> and msmerge_tombstone.bcp.
> The problem is that the snapshot agent generates bcp files for all of
> my tables. I will never use these and delete them as soon as they are
> generated.
> Does any know if it's possible to have the snapshot agent only copy the
> merge tables and not the user tables but still generate the other
> metadata scripts?
> Thank you,
> seanbell68@.gmail.com
>
|||There are times, such as after using sp_mergecleanupmetadata, when
snapshots are required to be regenerated. I also use a copy of the
publication database when creating new subscribers so the data is
already synced in that case as well. In fact, I have never used the
bcps generated for the user tables.
Tuesday, March 27, 2012
Customized Merge Replication Snapshot
Labels:
applying,
bcp,
customized,
database,
files,
merge,
microsoft,
mysql,
oracle,
replication,
server,
snapshot,
sql,
syncing,
whenapplying
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment