publication Properties, Snapshot Tab

Replication Wizard Help

Replication Wizard Help

publication Properties, Snapshot Tab

The following options are available on the Snapshot tab of the publication Properties dialog box.

Options

Native SQL Server format – all Subscribers must be servers running SQL Server

Specifies that the snapshot files will be in native SQL Server format.

Character mode format - supports heterogeneous Subscribers and data transformations using DTS

Specifies that the snapshot files will be in character mode format.

Do not lock tables during snapshot generation. All Subscribers must be servers running SQL Server version 7.0 or later.

Select this option to enable concurrent snapshot processing. This option is displayed with transactional replication. Publishing tables will not be locked while the snapshot is generated.

Before applying the snapshot, execute this script

Enter the network path for the script that you want executed before the snapshot is applied.

After applying the snapshot, execute this script

Enter the network path for the script that you want executed before the snapshot is applied.

(. . . )

Browse to the location of the script that needs to be executed.

See Also

Applying the Initial Snapshot

Executing Scripts Before and After the Snapshot is Applied

How Transactional Replication Works