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...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 ...ASE Replicator / ASE 12.5
Adaptive Server Enterprise/188.8.131.52/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...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...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...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 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 -> 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...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?
...Replication ASA-ASE stops because ASE is full
I have a replication between a consolidated DB on ASE and 4 remote DB on
During a replication, ssremote was unable to apply messages from the remotes
because the segments of the consolidated DB where full.
The message of ssremote was :
E. 03/31 06:00:06. bourget: Error 1105: Can't allocate space for object
'depot' in database 'stp_qual' because 'default' segment is full/has no free
extents. If you ran out of space in syslogs, dump the transaction log.
Otherwise, use ALTER DATABASE or sp_extendsegment to increase size of the
I have increas...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 11.9.2 -> ASE 12.5 Migration over Replication Server?
I've heared about the possibility to migrate an ASE (11.9.2->12.5, both
32bit) over the Replication server.
Is it also possible with this solution to increase the page size (old ASE
11.9.2 with 2k -> new ASE 12.5 with 4k)? If yes, could anybody explain me
please how that works?
We've been using Rep. Server only for warm standby.
Thank you in advance.
AOL Deutschland � Millerntorplatz 1 � 20359 Hamburg � Germany
+49 (40) 36159-7454 � fax: +49 (40...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 ...