Replication of table definitions

Question

Hi,

I am new to SQL2008 R2. I successfully set up a transactional replication. Also, when I change a definition of an existing table it is replicated to my subsciber.

But when I create a new table it is not replicated. Is there a way to set up a replication that automatically replicates the new table to a subscriber?

Or, if not - what is the best way to manually replicate the new table in the subscriber and then expand the replication so that the data of this table is replicated as well?

(Do I have to create a completely new replication for this?)

Thank you
Thomas

 

Answer 1

But when I create a new table it is not replicated. Is there a way to set up a replication that automatically replicates the new table to a subscriber?

After creating the new table, you'll need to add it to your publication.

Or, if not - what is the best way to manually replicate the new table in the subscriber and then expand the replication so that the data of this table is replicated as well?

Please see the section Adding Articles in Adding Articles to and Dropping Articles from Existing Publications.  You'll need to add the new article, generate a new snapshot, and synchronize your subscription(s) to apply the schema and data for the new article.

(Do I have to create a completely new replication for this?)

No, all you need to do is add the new article to your publication.

Hope this helps.

---

sqlrepl.com

Answer 2

Shewanja,

 Please refer this

http://msdn.microsoft.com/en-us/library/ms152493.aspx

Answer 3

Hi - sorry, it took me a while to respond. However the proposals you made seem to be my solution, I will test it as soon as possible

Thank You!

Answer 4

Thank You!