Use Publications to Replicate Data at the Command Line

Learn how to create a publication to replicate data at the command line and prepare the publication for subscription. In addition, learn how to modify and drop a publication and its associated articles and replication definitions.

• Commands for Creating and Managing Publications
  There are several commands you can use to manage your publications.
• Creating Publications and Articles at the Command Line
  Learn how to use RCL commands to prepare a publication for subscription and create a subscription against it.
• View Publication Information
  Use the check publication command and the rs_helppub stored procedure to view information about publications and articles.
• Alter Publication Information
  If you want to alter an article or publication, you must drop the article or publication and re-create it. You can also make the where clauses in an article more selective.
• Adding Articles to a Publication
  Learn how to add articles to an existing publication.
• Drop Publications
  Use drop publication to remove a publication and all of its articles from the system tables.
• Drop Articles
  Use drop article to remove an article from a publication.