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...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...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...Performance advantage of ASE 64 Bit over ASE 32 Bit version
Is any there any performance gains when using ASE 64 bit
versus ASE 32 bit version like larger memory gains hence
The more memory , the more data you can cache, the better performance.
<Jayesh> wrote in message news:email@example.com...
> Hi Folks,
> Is any there any performance gains when using ASE 64 bit
> versus ASE 32 bit version like larger memory gains hence
> good performance?
> The more memory , the more data you can cache, the better...Performance issues after upgrate ASE 11.5 to ASE 12.5
How can we improve performance?
We're moving a database that was operating fairly well on a HP-UX 10.20 with
Adaptive Server Enterprise v. 11.5 (32 bits) to a HP-UX 11.0 with Adaptive
Server Enterprise v. 12.5 (32 bits)
Our problem is the slower performance of the database on the new, more
powerful and faster machine with newer software (in both operative system
and sybase version)
We've noted that it starts really fast but slows down gradually.
We�ve tried many ways to improve the performance:
-Increase the max memory.
-Increase the number of engines at startup...Performance Degradation after ASE 12.0 upgrade to ASE 12.5
There was a issue posted on 08/06/2002 by 'Bob' related to performance
degradation after upgrade of ASE 11.9.2 to ASE 12.5. I would like to know
whether anyone has found any solution/workaround
to resolve those issues without making any changes in the application code.
We are also facing the same problems here after upgrade of ASE 12.0 to ASE
12.5. The program which takes 10 mins. on ASE 12.0 is taking more than 3
hrs to finish on ASE 12.5 despite of using the same indexes and the program
which takes 3 hrs on ASE 12.0 is taking more than 24 hours on ASE 12.5. ...ASE 12.5 vs ASE 11.5 performance issues
Again my question is about performance of ASE 12.5 against 11.5.01
We have a huge production client-server application running on W2K server
with ASE 220.127.116.11 database (more than 400 tables, 2000 stored procedures).
The database was placed on raw disk partitions (no RAID) and split between
different physical drives as follows: data, log, tempdb and master database
are located on different drives.
We have two PIII, 1GHz, 1 GB of memory and give 800MB for ASE. We create
separate tempdb cache and bind tempdb to it. Database was bind to default
Then we want to switc...Performance issues after upgrate ASE 11.5 to ASE 12.5 #2
How can we improve performance?
We're moving a database that was operating fairly well on a Sun 3000 with=20
Adaptive Server Enterprise v. 11.5 (32 bits) to a Sun 10000 with Adaptive=20
Server Enterprise v. 12.5 (64 bits) and Solaris v. 8
Our problem is the slower performance of the database on the new, more=20
powerful and faster machine with newer software (in both operative system=20
and sybase version)
A particular query with insert used to work for about 2 hours in a Sun 3000=
with Adaptive Server Enterprise v. 11.5 (32 bits).=20
In a Sun 10000 with Adaptive ...ASE optimizer behavior differences and Performance differences between ASEs: 11.50/ 11.9.2
I wish I could report that the 18.104.22.168 ASE is performing better then our
11.50 AS instances, but then I would probably not be submitting this post.
I have two similar ASE instances which appear to have identical
table,indexes,segments,devices. The row counts of the two tables are only
off by 1000 and that is expected. Showplan reveals that the optimizer is
behaviing very differently between the two instances , not supprised. The
new 22.214.171.124/1175/P/SWR/9520 ASE is performing poorly and I can not proced
with upgrading my other servers to 11.9.2 untill I accertain the performanc...Diferrence of performance on queries betwenne a ASE 126.96.36.199 and ASE 12.0
I'm on the way to migrate from ASE 188.8.131.52 (on HP-UX 10.0) to ASE 12.0 (64=
bits on HP-UX 11).
My tests shows good and bad performance with queries.
I'm very interesting with yours.
Can you tell me about them.
There are major functional changes in ASE 11.9.2 and above. I'm glad to see
How did you get the data to 12.0?
Have you turned on any of the 12.0 options?
HAve you attempted any tuning?
What, if anything, have you done so far?
If you have a specific problem query that can b...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...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 ,
...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