1)what is the difference between Reinitializing a Subscription and synchronization the subscription? when to use reinitializing ? when to use synchronization?)when adding table or deleting a table what to do?(reinz.. or syn) when adding a column what to do?
Welcome to the forums. Is this a interview Question? The answer depends on the type of replication that is used here, from Books online : When you create a subscription, you can define a synchronization schedule that controls when the replication agent for the subscription will run. If you do not specify scheduling parameters, the subscription will use the default schedule. By default, a subscription to a transactional publication is initialized with a snapshot, which is generated by the Snapshot Agent and applied by the Distribution Agent. In some scenarios, such as those involving large initial datasets, it is preferable to initialize a subscription using another method.