on 10-31-2014 9:00 AM
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.