Applying the initial snapshot

The initial snapshot for replication ensures that all sites have synchronized data before replication begins. If you are running replication in a homogeneous environment, select the first option. This has the effect of SQL Server running the BCP with the /n parameter for a native format. This creates the sapshot output in the same data structure that SQL Server uses to store data. This is the most efficient transfer method that can be used between two SQL Servers. If you are using heterogenous replication, you will need to specify the second option. This creates the output in a character format that is readable by any program. For this example, select native format and click the Next button to display Figure 14-24.

Replication Primer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40