Creating a Publication v6.2

Creating your first publication requires the following steps:

  • Registering the publication server
  • Adding the publication database
  • Creating a publication by choosing the tables and views for the publication along with creating any optional filter clauses

Once the publication database has been added, as many publications can be created as there are available tables and views that are readable by the publication database user and that meet the criteria outlined in Design Considerations and Restrictions on Replicated Database Objects.

registering_publication_server adding_pub_database adding_publication control_schema_objects_created_for_publication