Replicating trigger action with SQL remote (SQL/Anywhere)
I need to replicate the actions of a trigger in one of my tables. I've
tried to use the -t option when running dbremote, but this still does not
replicate the trigger actions. Is there a solution to this problem?
I need to replicate the action of the trigger because I'm trying to do the
I need a sigle unique id for record in a table, and that table may be
inserted into at any number of remote databases, and at the consolidated
database. I've used an autoincrement column and a current publisher column
as the actual unique primary key, and have another column ...SQL Anywhere 8.0.2 SQL Remote FTP replication problems
I have a problem setting up the FTP message control parameters with SQL
I use the SET REMOTE FTP OPTION statement to do this. See an example.
Considering a remote user with name 'pippo'...
SET REMOTE FTP OPTION pippo.host = 'my_host';
SET REMOTE FTP OPTION pippo.user = 'mickey';
SET REMOTE FTP OPTION pippo.password = 'mouse';
SET REMOTE FTP OPTION pippo.root_directory = 'root_dir';
These four statements set FTP parameters for the pippo database user.
This means that I want that the user pippo gain access to the replicati...SQL Remote replication problem
We have an ASA 184.108.40.2066 setup with several branches replicating to and
from a consolidated database via SQL Remote. At each end we have the
following trigger on one of our tables:
DBA.tub_item before update on auction.item
referencing old as old_upd new as new_upd
for each row
if current remote user is null then
set new_upd.last_modified_by=current user;
The problem that sometimes occurs is this. A user updates a field on the
item table, which fires the trigger. The update action and the tr...ASA Replication With SQL Remote
We are beginning with a replication among two databases ASA 7.0. We use SQL
Remote to achieve that goal.
First, we create users publisher and remote, after we create publications
and articles. At last we did extract process for create remote database.
In each site, we launch Replication Agents using SMTP.
Changes in Consolidated Database replicates in Remote Database but changes
in Remote Database has no effect on Consolidated Database.
Someone can tell us Which are basics troubleshooting for replication using
SMTP and SQL Remote?
Why Remote Database does not replicate to Co...sql remote with replication enterprise
can I run sql remote and replication enterprise on the same machine?
My system has 3 units ASA --- ASE --- ASE so the middle one
need to replicate with ASA and ASE on the same machine.
In order to have SSRemote and the Rep Agent for ASE run on the same database
you must use SSQueue.
This was available in a 5.5.04 EBF, which also means you must be at least at
5.5.04 of SSRemote.
Please contact technical support and ask for an EBF for 5.5.04, including
Please post only to the news group.
Songrit Leemakdej wrote in message ...
>can...ASE Replicator or SQL Remote
We have several 11.9.x servers running on RH Linux that we need a simple
replication solution for. These severs will be upgraded to 12.5 over a
year or so. Rep sever seems overkill. I have been looking at the new ASE
Replicator in 12.5 and SQL Remote that was designed for 11.9.x. Here are
If I set up one 12.5 db and use it as the primary database can it publish
data to the 11.9.x servers?
Is SQL Remote going to be a supported product or is Sybase encouraging
users to move to Replicator?
Does SQL Remote run on Linux?
Which is eaiser, more reliable?
T...Security in SQL Remote replication
Does anyone know, how replication messages (sent via e-mail) are secured?
What kind of encoding algorithm is used? Is it safe? Is it dificult to
The messages are encoded, but not encrypted. The encoding is meant to stop
casual viewers from reading the data in your messages, but is no intended to
stop serious hackers. If security is a concern, you can always write your
own encoding dll. Check out the following section of the manual :
Replication and Synchronization Guide
PART 3. SQL Remote
CHAPTER 18. SQL Remote...SQL Remote and ASE Replicator
Is it possible to use SQL Remote and ASE Replicator on the same database?
SQL Remote and Replication Server for example have such capability when you
Both the ASE replicator and SQL Remote for ASE need to exclusively manage ASE's
secondary truncation point in order to identify the oldest data page in syslogs
that they need to start scanning from. There is only 1 secondary truncation
point, and by the nature of it, it can not be shared between processes to
identify more than one page.
This is why we included the SSQueue as a solution for an ASE ...sql remote, replication server
I have a main location, where Sybase ASE and most users are sitting, and one
secondary locations connected through internet where more users access main
database with PowerBuilder applications. Of course, in the secondary
location PB applications run slow.
People in the secondary location does a lot of read from database, and few
I tried web deploy kit, but it is too slow (we need LOTS of stuff on screen,
Now I think of having two databases, that are kept synchronized by
"something" (e.g. overnight).
My question is, what should "s...SQL remote TIMESTAMP replication
ASA, however is the timestamp format set, maintains the full 6-digit
fraction of second.
It would be a ***VERY FINE*** (that's three stars from both sides with caps
on) thing if the timestamp column would replicate in a ***FULL*** format,
whatever the option 'timestamp_format' would be set to, because when
replicating such a column with 'timestamp_format' set to '....nn.ss.sss'
(what I believe is the default setting), only the 'ss.sss' is replicated and
I believe ASA adds the missing three digits manually (.sss000, .sss001,
..sss...SQL remote replication stops
I have a problem with SQL Remote replications via FILE (the same with
another message types).
dbtran and dblog are not showing any errors. there is no gap/space in log
Remote site is only getting messages from consolidated, but nothing sending
to consolidated. When dbremote starts, it shows correct start of transaction
log, starting scan and finishing without any outcoming message.
Seems like dbremote is not scaning log or checking bad offsets.
I. 10/27 15:57:03. Transaction log "c:\test\03101600.LOG" starts at offset
0006864...Replication Server and SQL Remote
I want to know about if anyone is working with Replication Server and
I want to use RS to replicate with connected sites (ASE Servers) and
DBremote to replicate with disconnected ones (ASA Servers).
According with Sybase Support I must put an intermediate ASA server with Rep
Agent for ASA working as gateway between disconnected sites and the central
We are thinking in the following products:
* Central Server: ASE 11.9.2 y Replication Server (UnixWare 7.1)
* Intermediate Server: ASA with a consolidated DB, and using dbremote.
* Remote Sites disconn...SQL Remote message "A SQL Remote message has been deleted"
I have got the following message will sql RemoteAgent is sending messages at
the conslidated database
I. 03/14 02:08:53 A SQL Remote Message has been deleted
And the message has been repeated 20 times before sending again
I am using SQL Anywhere 5.5.05 Build 2509
and SMTP messaging
This message was posted during the sending phase and not the receiving
Did you go to an old backup of the consolidated database without applying
log files to get you back to the same point before you started recovery?
"Haytham Arafa" <haytham...