<div>
<div class="content wysiwyg-content">
Hi experts<br />
<br />
I have here a merge replication to 5 location over the world. I have one distributor and 5 subscribers.<br />
So, now I want to add a new Article to all 5 Subscribers ( a new table for example).<br />
<br />
How is the easiest way to do this because the hole database has a size of about 2GB of data? Is it possible to add this article without doing a complete Snapshot over the complete database?<br />
Does a Snapshot delete all records at the subscribers and copy it again from the publisher?<br />
<br />
Thank you
</div>
</div>


Hi experts

I have here a merge replication to 5 location over the world. I have one distributor and 5 subscribers.
So, now I want to add a new Article to all 5 Subscribers ( a new table for example).

How is the easiest way to do this because the hole database has a size of about 2GB of data? Is it possible to add this article without doing a complete Snapshot over the complete database?
Does a Snapshot delete all records at the subscribers and copy it again from the publisher?

Thank you

merge replication - add new article

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.