Replication between ASE and ASE URGENT
Can you help me please with the following question.
We need to syncronize ASE to ASE ( bidirectional)
Initially, it was planned to implement with SQL remote, but it isn't
With replication server, it isn't a solution beacuse, the customer
doesn=B4t have a comunntication channel all time.
We think use Mobiliink Server to replictase ASE to ASE, but using an
ASA in the middle, so that,
first it replicate ASE to ASA, and later, ASA to ASE, is it this
Thanks four your answer
"Marco" <firstname.lastname@example.org> wr...ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to
ASE and ASE To ASE ?
You should start with the Help file and then ask specific questions:
Data Replication with SQL Remote
PART 5. Appendix
APPENDIX A. Enterprise and Anywhere: Differences
There are many differences, so begin there.
Please only post to the newsgroup
BH Ong <email@example.com> wrote in message
> What are the differents in terms of configuring SQL Remote Between ASA to
> ASE and ASE To ASE ...Replication between ASE and ASA
1. My consolidated database is using ASE and remotes are using ASA. Do I
have to install the PC Client for ASE at the remote site?
2. Why do I received the 'unlink ......' message as below? And why do I
have to run dbremote and ssremote twice in order for the hq to receive the
data from field? Where did I go wrong?
dbremote ?c ?eng=fielddb;dbn=fielddb;uid=DBA;pwd=SQL;CommLinks=tcpip?
E. 08/07 12:54:40. Deleting corrupt message
I. 08/07 12:54:40. unlink "field\field.log" failure 5: Permission denied
I. 08/07 12:54:40. unlink...Replication from ASA to ASE
I can't replicate, using the exemple in the Data Replication with SQL
Remote, but I replicate only from ASE to ASA.
are there a tutorial for this?
please help me.
Thanks in advance.
Leopoldo Carvalho de Lima
What problem are you encountering?
Please Respond to Newsgroups
John A. Sandoval wrote in message ...
> I can't replicate, using the exemple in the Data Replication with SQL
>Remote, but I replicate only from ASE t...ASE
We try to configure a replication system. Our primary site is Adaptive
server 12.0 and remote sites are ASA 7.
We want to use Replication server.
At remote site, do we need an ASE ?
Which Replication agent will we use for each site.?
Do know a document for ASE- ASA replication?
Thanks in advance for your reply.
Sybase iAnywhere Solutions
Please reply only to the newsgroup
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Fra...Replication between ASE and ASA
Can somebody please answer my question:
Is it possible to setup a replication between ASE 12.0 and ASA
6.03 using SQLREMOTE or we have to use Replication server...
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii
John Smith wrote:
> Can somebody please answer my question:
> Is it possible to setup a replication between ASE 12.0 and ASA
> 6.03 using SQLREMOTE or we have to use Replication server...
Yes, you can use SQL Remote. Take a...ASE Replicator / ASE 12.5
Adaptive Server Enterprise/18.104.22.168/EBF 10696 IR/P/Linux Intel/Linux
I had started ASE Replicator with primary connection xxx (with
subs,articles,etc.), then I changed primary connection into yyy (and the
rest). Everything was fine. But when I try to back to xxx primary connection
Sybase returns me this error:
1> sp_addprimaryconn "xxx"
Msg 32000, Level 20, State 0:
Server 'ASE_Rep', Procedure 'sp_addprimaryconn', Line 1:
Command <sp_addprimaryconn> failed - Could not add Primary...Replication ASE
How can i replicate data between 2 ASE servers using SQL Remote, because
when i use ssxtract it extracts a anywhere database .db.
other question is i wanto replicate data via email, is microsoft exchage
server enough for this or i'll need other mail server.
thanks in advance
jmcd wrote in message <37616E0E.91D29322@else.com.pe>...
>How can i replicate data between 2 ASE servers using SQL Remote, because
>when i use ssxtract it extracts a anywhere database .db.
I try this type of replication. In documentation i d...2-way replication from ASE to ASE
We are looking at implementing replication server bi-directional.
Specifically, we have two databases (for redundancy) on two differnet
physical servers, two different ASE databases, but the two databases are
named the same, and same architecture.
Sybase Learning suggested the only way to do this is to use stored
procedures (request function). This is not really bi-directional and does
not have the data available in the secondary immediately. Using stored
procedures will cause a complete re-write of the application, so it is not
really worth it.
What we wanted it to do is that i...ASE to ASE replication using SQL Remote
Since 11.9.2 comes with SQL Remote, can I use it for replication from ASE to
ASE instead of a more expensive Replication Server?
Yes you can. A couple of considerations:
1) SQL Remote is not intended for near real-time replication. Even with the
new hover mode features, you should plan on at least 1 minute latency in
2) SSXtract does not support automatically extracting a remote ASE database.
You will have to manually configure the remote and consolidated databases,
including the initial synchronization of data before you start replication.
This is certainly...ASE to ASE replication using SQL Remote
Since 11.9.2 comes with SQL Remote, can I use it for replication from ASE
to ASE instead of a more expensive Replication Server?
...ASE -> ASE replication with NFS mount
I'm still evaluating SQL Remote on ASE 11.5.1 to replicate data between two
servers. All my tests to replicate database between two databases on the
same server work fine using the file system as a way to replicated data. I
am now trying to replicate a database between two servers still using the
file system but using an nfs mount versus ftp but it does not work, the data
is never relicated.
Does the directory structure need to be the same on both machines?
On the source server the directory structure is:
/sybase_backup/replication/t...what do I need for the ASA-ASE replication?
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<br>Would you please anyone write me the (main) steps of ASA-ASE replication?
You may want to look at this white paper:
Jim Egan [TeamSybase]
How about this:
Data Replication with SQL Remote
PART 1. Introduction to SQL Remote...ASA to ASE replication problem
I have implemented e replication system ASA-ASE. It works fine from ASE to
ASA but when there are message from ASA to ASE the system has a "object not
found error". I run the message agent, ssremote, in verbose mode and I see
insert into "dba"."table_name"
the error is caused by the prefix "dba"
How can I do to eliminate "dba" prefix?
I must work in ASA parameter or in ASE parameter?
Look at the following option in the Help file.
Adaptive Server Anywhere Data...