15052: primary and replicate database cannot be the same

Symptom

The following error message is displayed in the Replication Server error log:

Error #15052: “The replicate database '%s.%s' for
subscription ‘%s’ is the same as the primary database
for the replication definition '%s'. This is not
allowed."

Explanation

You cannot create a subscription in which the replicate database is the same as the primary database.

Solution

To correct the problem:

  1. Create the replicate table on a different database.

  2. Execute the create subscription command again.