When Source and Destination Tables Share the Same Name

When the source table and all destination tables share the same name but you want to give the replication definition a different name, use with all tables named to specify the table names.

For example, to create a replication definition named publishers_rep for source and destination tables named publishers, enter this command:

create replication definition publishers_rep
with primary at TOKYO_DS.pubs2
with all tables named publishers
...