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...sql-remote between ASE and ASE
sql-remote document don't give us help with replication with ASE and ASE.
i need detail how to do it.
i use ASE12 + NT4.0 + SQL Remote6.0.2 .
i test it in the list
1�� define messagetype : smtp
2�� define use_name :one is publisher,the other is remote user_name
3�� define publisher,publication,subscription
4��execute ssremote.exe to receive or send message
I failed at the step of extract database .i don't extract the database .
please help me ,tell me the datail of sql-remote confige.
Thanks a lot ,
...sql remote ase to ase
can I use sql remote ro replicate data form ase to ase or only from asa to
ase and asa to asa ?
I would also recommend that you read over the following tech doc;
Implementing ASE to ASE Server SQL Remote Replication
Reg Domaratzki wrote:
> Just be aware of the limitations pointed out in the documentation when using ASE as a remote database.
> Replication and Synchronization Guide
> PART 4. Appendixes
> APPENDIX A. Enterprise and Anywhere: Differences
> Limitations ...SQL Remote ASE
did anybody know when SQL Remote support blob (image, text) replicacion for
ASE - ASE?
our company need this feature.
electro sur este s.a.a.
Support for image and text replication with SQL Remote went in as of ASA 6
and SA maintenance 5.5.04 build 1938.
Sybase Technical Support
> did anybody know when SQL Remote support blob (image, text) replicacion for
> ASE - ASE?
> our company need this feature.
> joan caceres
> electro sur este ...Remote admin of SQL Remote folder under ASE 11.9.2?
(I've posted this to SQLServer.NT as well)
I'm able to see and manage the SQL Remote folder for ASE when I'm
working locally of the ASE Server; however, when I connect to the ASE
server with my laptop, the SQL Remote folder does not appear.
Is there a plugin needed to remotely manage ASE SQL Remote
installations? Am I missing something obvious? OR, is there no
support for this CRITICAL feature?
Yes, there is support.
Here is the files you will need to get this working.
In the directory where the ASE 11.9.2 plugin DLL resides, you should ...Replicate SQL Anywhere Text column to ASE using Replication Server
Is it possible replicate text column in SQL anywhere 5.5.04 using
Replication Agent for SQL Anywhere and Replication Server 11.5 to Adaptive
yes. Replication of BLOBs works fine
Manager Custom Support
Sybase Canada Inc.
virginia cheung wrote in message <01bdf3e7$6ed5c420$010414ac@star>...
>Is it possible replicate text column in SQL anywhere 5.5.04 using
>Replication Agent for SQL Anywhere and Replication Server 11.5 to Adaptive
>Server ...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...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 ...ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE
Any information is welcome
ASA supports a fairly large sub-set of Transact-SQL, so if you write your
stored procedures and triggers in ASA using T-SQL, you should be able to
create scripts that will run against both ASE and ASA. If you're planning
to do this though, I would suggest developing your database schema against
ASA, since everything you write in T-SQL in ASA will be supported on ASE,
but the reverse is not true.
Check out the section in the ASA documentation entitled "Tra...ASE to ASE
Is anyone out there doing ASE to ASE replication using SQL remote? If
you are have created your own version of the SSEXTRACT utility to set up
a replicant database in ASE rather than ASA? Or does anyone know if
SYBASE has created a version SSEXTRACT for use with ASE to ASE
Thanks in advance
I thought the SQL Remote Replication support in ASE11.5 was meant for a
consolidate-database only (by design)! At least that was what Sybase
said when they announced support for SQL Remote technology support in
I will be happy to...ASE Replicator & SQL Remote
How do I use ASE Replicator as the consolidated and ASA 6 SQL Remote as the
remote? Where can I read notes on this topic or is it same as in the
previous version of ASE (using ASE SQL Remote)?
AFAIK they cannot interact.
Technical Services Manager
- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
<Liza_A.S> wrote in message
&g...upgrade ASE database with SQL remote replication
The SQL remote replication is between ASE and ASA database. Does the
secondary truncation point need to set 'ignore' before the ASE database is
You do need to ignore the secondary truncation point with
dbcc settrunc( 'ltm', ignore')
in the ASE database before upgrading. Of course your log should be totally
drained using ssremote -i, before doing that.
After successfully upgrading you have to set that back to 'valid'
"liy" <LI_YUPING@bls.gov> wrote in message
news:%23r8X8U8SDHA.3...ASE 11.5 Replication with SQL Remote
Has anybody gotten ASE 11.5 for NT to replicate using SQL Remote ? There
seem to be problems using SQL Remote as the agent to replicate between ASE
11.5 nodes ?