All geek questions in one place

Will a change in the schema of a replicated object affect replication?

We have two DB instances on our SQL 2000 server, and about 10 tables from DB 'A' are replicated to DB 'B'. No matter what change we make in the DB 'A' tables, they are replicated to the DB 'B' tables. We added a column to one of the tables in the database "A". Do we also need to change the table in the database "B"? Or does it depend on how the replication was configured (which I don’t know, since it is configured by someone else)? Will he throw any errors when replicating data?

+4
source share
2 answers

This depends on whether the option “Replicate schema changes” in the “Subscriptions” panel of the “True” or “False” publications when setting up replication was selected. The default value is True, which means that schema changes are replicated.

For more information on limitations and exceptions, including the differences between merging and transactional replication, see "Implementing schema changes in publications." Do not miss this little nugget:

Schema changes in tables must be made using Transact-SQL or SQL Server Management Objects (SMOs). When schema changes are made to SQL Server Management Studio, the management studio attempts to reset and recreate the table. You cannot publish objects, so changing the schema fails.

+6
source

Replication will add a new column to table "B".

0
source

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

More articles:


All Articles