cancel
Showing results for 
Search instead for 
Did you mean: 

Is possible to replicate temporary tables on Replication Server 15.7 with Sybase ASE 15.5?

0 Kudos

Hi Guys

Actually, we have a MSA (multisite) configuration on replication server 15.6, this configuration has one primary site and two secondary replicate sites.

When an stored procedure is executed and inside it has a temporary table, the connection that tries to replicate this procedure falls down

How can we dismiss this problem?

Is this posible on Rep Server 15.7?

Thank you for your help

Best Regards

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Jairo, any news? Was the suggested solution helpful?

0 Kudos

Hi Vincent,

Thank you for you follow up

We are going to testing your suggestion on a test system, we hope make test next week

Regards

Former Member
0 Kudos

You should try to configure temporary the option "ddl in tran" on the tempdb of the replicate databases. In my case it replicates well when I create a new procedure with temp tables on the primary db server. Do not forget to remove this option after being replicated.