Contents
When do I add e new table its not getting replicated?
Reinitialization is not required, but a new snapshot is. This is covered in Add Articles to and Drop Articles from Existing Publications. Every table/object marked for replication is a separate article in the publisher set up.
How to replicate schema changes on publication databases?
To replicate schema changes, the compatibility level of the publication must be at least 90RTM. If Subscribers are running previous versions of SQL Server or the compatibility level is less than 90RTM you can use sp_repladdcolumn (Transact-SQL) and sp_repldropcolumn (Transact-SQL) to add and drop columns. However, these procedures are deprecated.
How to create a new publication in SQL Server?
To create a new snapshot, see Create and Apply the Initial Snapshot. To create a new snapshot for a merge publication with parameterized filters, see Create a Snapshot for a Merge Publication with Parameterized Filters. After the snapshot is created, synchronize the subscription to copy the schema and data for the new article.
When does SQL Server propagate to all subscribers?
When you make any of the following schema changes on the appropriate published object at a Microsoft SQL Server Publisher, that change is propagated by default to all SQL Server Subscribers:
How does transactional replication work in SQL Server?
Replication has already been setup with the subscriber, so on the subscriber instance the same table, Customers, exists in the database Customer_DB. According to the concept of transactional replication, row and data changes made on the Customers table at the publisher, replicate to the subscriber table Customers.
When to add a new article to an existing SQL Server publication?
When setting up replication, you never know what new database changes will occur, so there is often the need to add additional objects to the publication. In this tip we will look at how to add a new article (database object) to an existing SQL Server publication.
How to reinitialize a subscription in replication monitor?
A dialog box Reinitialize Subscription (s) opens. Select Use a new snapshot and then click the Mark For Reinitialization button. We must create a new snapshot after adding the new articles. The new snapshot can be generated using Replication Monitor.