Skip to Content
0
Feb 05, 2022 at 01:58 PM

Excludeing tables from replication

242 Views

Dears, in sybase replication warm standby between 2 ASE databases, what happen when we set replication by sp_reptostandby

then excluding some tables ?

We periodically exeute a stored procedure by an application, this proc issues thousands of transaction against some tables, so we excluded those tables at the replication server by alter connection and use u2none, i2none, d2none, and after each execution for that proc on active database, we run it on standby database, but we think this solution is not optimal as we found those transactions arrive to rep server( we found them in stable queues) then it decides to not excute them on standby db , so how rep server deals with the transactions on exclude tables, and is there a better solution for this case?

Regards