We're replacing old type repdef/pub/article/subscription replication with MSA replication (database subscription replication).
With the old pubsub replication, if we didn't create a repdef/article, it would be excluded from subscription replication (good for work tables that need to be on the primary only)
But with MSA/database subscription replication, all the tables included with warm standby replication also get included with MSA replication (I think...)
So, if I have a database setup for warm standby replication with settings:
> sp_reptostandby testdb1;
The replication status for database 'testdb1' is 'ALL'.
The replication mode for database 'testdb1' is 'off'.
> sp_config_rep_agent testdb1,"send warm standby xacts";
Parameter_Name Default_Value Config_Value Run_Value
----------------------- ------------- ------------ ---------
send warm standby xacts false true true
And where I've added a database subscription (aka MSA replication) using:
create database replication definition my_db_rep_def ...
create subscription <db_sub_name> for database replication my_db_rep_def
Is there a way to have a specific table in the primary NOT replicate for the database subscription but still replicate for the warm standby?
My quick test using
sp_setreptable mytable,'false'
Didn't stop replication for the database subscription.
Setting sp_setreptable mytable,'never' stopped warm standby replication too, which I don't want.
Thanks in advance and apologizes if I'm missing some thing obvious here.
Ben
Request clarification before answering.
Ben
You don't need the clauses for the functions or system procedures. We have those because we do bi-directional replication using MSA and need to avoid transactions doing ping-pong between servers. We do the REPLICATE DDL only on the repdef of one side for the same reason, the other side has NOT REPLICATE DDL and we limit DBA changes to one side so they replicate one-way only.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.