August 4, 2009 at 10:01 am
I want to set up one to many replication. If the table does not exist at the subscriber for the first synchronization does sql create it automatically? If not how can I do this without having to go to each server and manually create the tables.
August 4, 2009 at 10:10 am
messenjahofchrist (8/4/2009)
I want to set up one to many replication. If the table does not exist at the subscriber for the first synchronization does sql create it automatically? If not how can I do this without having to go to each server and manually create the tables.
Yes, If you are initializing through a snapshot replication, all the articles are pushed to the subscribers. The snapshot agent creates the schema and initial data to a working folder from where it is moved to the distribution database and then the distribution agent pushes the data to the subscribers. If you are synchronising through a backup, then all articles will already exist on each subscribers. I'm referring to transactional replication here.
August 4, 2009 at 10:13 am
Ok. I thought so. What I am doing is adding an article to a pulication. I'm setting the article to keep existing unchanged and I got the error at the subscriber saying it couldn't find the table. I also tried to Drop existing table and create a new one and I received the same error. any Ideas? Thanks for your first response.
August 5, 2009 at 8:06 am
If you are adding an article to a publication, you got to re-initialize the snapshot so that new article also becomes a part of the snapshot and hence will move to the subscriber.
If you dont want to re-initialize the entire publication, there is a workaround to add an article.
Please go through THIS link.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply