All geek questions in one place

Transactional Replication Issues

I have the following questions about how transactional replication handles the following. For example, suppose database “A” is replicated (through transactional replication) to database “B”.

  • If the table in database “A” is dropped, the table will be omitted in “B?
  • If the table in 'A is renamed, what happens to the table in' B?
  • If we put a column in a table in database "A", what happens to a column in the same table in database "B?
  • If we rename a column in a table in database "A", what happens to a column in the same table in database "B?
  • Replication of stored procs, views and UDF is optional?
  • Is there a way to avoid all stored processes created in database “B” as a result of being a replication subscriber? and. If not, can we at least determine in which scheme they are created?
+3
source share
1 answer

You will answer most of the questions: Frequently Asked Questions for Replication Administrators

  • You cannot delete a table that is replicated. You must first delete the article.
  • You cannot rename a table that is being replicated. You must first delete the article.
  • Issuing ALTER TABLE ... DROP COLUMN to Publisher will replicate the command to the subscriber.
  • "", . .
  • , .
  • ?

, . , , .

+5

Source: https://habr.com/ru/post/1777721/

More articles:


All Articles