I use SQL Recurrence (a transaction, a publisher / distributor with multiple subscribers, using SQL 2005 on the website ) And being searched and searched for Google everywhere and for this
I'm curious - do I really have to make a snapshot to create new things for promotion, or adding it New object in the list (for example, tables, stored actions) Process, function) remote client to stretch it?
Thank you, but I'm still confused I have a standard transaction related replication with the initial snapshot function, where the Master SQL 2005 database is actually synchronized with a subscription node (machine) . But when I add new sprocs or tables to the publishers, and add them as a paragraph for publication, they do not take themselves on the subscribing box. Checking both the membership and the properties of the publisher does not reveal any changes, which will have to repeat these changes. (I have "repeat schema changes are going on.) I have to remember something simple ... it can not really be true that every time I create a new sproc or table or UDF, I create a new snapshot What is the whole DB, is it?
You need to run the snapshot, but it only The same publicity has changed (what's new).
Comments
Post a Comment