Maz
Maz

Reputation: 31

How can I replicate between two tables with different names?

While setting up the database replication, the destination table that is getting created is having the same schema name of the source table. I want to have a different destination schema. But how do i get it?

Upvotes: 3

Views: 2986

Answers (1)

Paul Sasik
Paul Sasik

Reputation: 81507

Your question is addressed directly in this forum post.

Snippet:

...change destination_table to the new table name in sp_addarticle, or in the wizard, when you get to article dialog, highlight the table, click the Article Properties drop down, and select set properties of highlighted table article, and in the destination object name enter the name of the article.

Upvotes: 2

Related Questions