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 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...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 <firstname.lastname@example.org> wrote in message
> What are the differents in terms of configuring SQL Remote Between ASA to
> ASE and ASE To ASE ...Adding ASE to existing ASE-to-ASE Installation
I am using all ASE's in my SQLRemote setup.
My current installation consists of a Consolidated ASE & 2 Remote ASE's.
My attempt to add another Remote ASE to the existing installation
consists of these steps:
- Install the sqlremote system objects in the new Remote
- Install the stable queues in the new Remote
- Manually extract a bcp file of the shared table from the Cons
- Configure the Cons server for another subscriber
- Configure the new Remote's shared table, publications, &
- Manually b...ASE 12.0 and ASE 12.5 optional features
Can anyone knows what are the optional features of ASE 12.0 and ASE 12.5??
ASE 12.0 :
* DTM (distribute transaction management)
* HA (High availability)
* JAVA (Java support in the database)
* Security services.
* EJB support in the database.
* XFS (extended file system support)
* Directory services
* Extended full text search
* Java option now includes xml support in ASE.
<email@example.com> wrote in message
...Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
We are in the process of planning the upgrade of our ASE
12.5.4 dataservers to ASE 15.x. What is the most
recommended way to upgrade ASE dataservers from ASE 12.5.4
to ASE 15.x?
1) Install new instances of ASE 15.x and load database
dumps from our ASE 12.5.4 dataservers to the newly installed
ASE 15.x dataservers.
- OR -
2) Use the ASE upgrade utility (sqlupgrade) to upgrade our
existing ASE 12.5.4 dataservers to ASE 15.x.
What are the Pros vs. Cons for loading a 12.5.4 database
into a 15.x ASE dataserver versus performing an ASE
dataserv...ASE 12.0 High Availability
I have a license - related question:
I have 2 Compaq Tru64 4.0D and I am currently running a H/A environment that
was created under SQL Server 11.0.3 and later upgraded to 12.0 Now we will
transfer those servers to new hardware of same vendor using Tru64 4.0F.
Do I need to seperately license the H/A option or is this included in the
ASE software ?
I understand if that was the case, this would mean unbundling former
features in new versions.
Thanks for info.
Hi Reinhold. The ASE 12.0 H/A failover option is seperately licensed. If you
were ru...Welcome to the New and Improved ASE newsgroups
Welcome to the Sybase ASE newsgroups! We hope that you find the
forum a useful place to exchange information concerning the use of
Sybase ASE that will enable you to use it to greater potential. To
ensure that we all receive the greatest benefit from the forum, we
have a few guidelines concerning its use:
This forum was established by Sybase as a means of providing a
vehicle for its customers and prospects to openly and freely exchange
information and ideas. It is neither an alternative to, nor a
replacement for a Customer Support Contract.
...New to ASE
I'm new to ASE,
Can anyone recommend any reading materials other than what I find in the
excellent manuals published online?
Joseph Henry wrote:
> I'm new to ASE,
> Can anyone recommend any reading materials other than what I find in the
> excellent manuals published online?
"Niksa Jurinovic" <firstname.lastname@example.org> wrote in message
> Joseph Henry wrote:
>> I'm new to ASE,
>> Can anyone recommend any r...Solaris ASE to Linux ASE
We are looking into using Replication Server to Set up Warm Standby of
Production ASE databases - Primary site being on Solaris platform - Standby
Copy on Linux. Does any utilize this configuration ? What is the best way
to initialize data on the Standby Server ?
What other issues should I be concerned with ?
Technically you can setup Warm Standby across platforms. It may work well
too with Replication Server.
However, you cannot dump and load the databases (cross platform dump and
load not supported), hence there will be issues when you need to resync your
databases. Eac...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 ...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 ,
...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" <email@example.com> wr...