cancel
Showing results for 
Search instead for 
Did you mean: 

Excludeing tables from replication

suznCB
Participant
0 Kudos
324

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Mark_A_Parsons
Contributor
0 Kudos

Did you try running sp_setreptable <tablename>, 'never' in the PDB? [See this answer to your previous question.]