cancel
Showing results for 
Search instead for 
Did you mean: 

Replication (dbremote) between SA12 and ASA9

Former Member
0 Kudos

I get a lot of syntax error while replicationg between a SA12 and ASA9 database.

The consolidated db (SA12) sends SQL through passthrough to a ASA9 Remote db.

It seems that the SQL Syntax sent from SA12 is not compatible with the syntax that ASA9 expects.

Is there a way to preserve the original syntax?

Example:

Execute SQL at consolidated db (SA12)

ALTER TABLE tablename MODIFY columnname varchar(100);

On replication, the ASA9 database receives a non valid syntax for the same statement

ALTER TABLE tablename ALTER columnname varchar(100);

Which runs fine on SA12, but fails on ASA9

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The quickfix is to create a dummy temp procedure with the SQL as the procedure will preserve the alter syntax.

But are there any other best-practice solutions for this?

Answers (0)