Specify Snapshot Format (SQL Server Management Studio)

Specify snapshot format on the Snapshot page of the Publication Properties - <Publication> dialog box. For more information about accessing this dialog box, see View and Modify Publication Properties.

To specify snapshot format

  1. On the Snapshot page of the Publication Properties - <Publication> dialog box, select Native SQL Server - all Subscribers must be servers running SQL Server or Character - required if a Publisher or Subscriber is not running SQL Server.

    Note

    It is recommended to select the native format unless this publication must support subscriptions to a SQL Server Compact database or a non-SQL Server database.

  2. Click OK.

See Also

Tasks

Configure Snapshot Properties (Replication Transact-SQL Programming)

Concepts

Change Publication and Article Properties

Initialize a Subscription with a Snapshot