Creating a publication v7

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

After you add the publication database, you can create as many publications as there are available tables and views. These tables and views must be readable by the publication database user and 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