Publication Type

Replication provides the following types of publications:

  • Snapshot publication
  • Transactional publication
  • Transactional publication with updatable subscriptions
  • Merge publication

Which type or types of replication you choose for your application depends on the physical replication environment, the type and quantity of data to be replicated, and whether or not data is updated at the Subscriber. The physical environment includes the number and location of computers involved in replication, and whether these computers are clients (workstations, laptops, or handheld devices) or servers. For more information, see Types of Replication Overview.

Note

If you are running Microsoft SQL Server 2000 Personal Edition or Microsoft Desktop Engine (MSDE), the options Transactional publication and Transactional publication with updatable subscriptions are not available. These editions do not permit the creation of transactional publications. However, you can still subscribe to transactional publications.

Options

  • Publication type
    Select the appropriate replication type for this publication.

See Also

Other Resources

Publishing Data and Database Objects
How to: Create a Publication and Define Articles (SQL Server Management Studio)
Replication Properties
Replication Wizards

Help and Information

Getting SQL Server 2005 Assistance