ASE to Rep Server to Rep Server to ASE Configuration
I am hoping someone can help me. I am relatively new to Rep server
and definately new to this configuration. I am trying to set up
replication from ASE to Rep server to remote Rep Server to ASE. I am
doing this type of configuration because the one ASE server is in
North America and one is in England. This was recommended to me by
Sybase becuase the transformation/language of Rep Server to Rep Server
is quicker over the wan.
Anyway. I have a ASE to rep server to ASE configuration and had no
problem setting that up. Now I am trying to set up a new replication
environme...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 18.104.22.168 to ASE 12.5 and Rep Server 12.1
We are planning the upgrade of our ASE 22.214.171.124 64bit on AIX
4.3.3 to ASE 12.5 64bit on AIX 4.3.3. We are also using Rep
Server 12.1 with these two servers. My question is do I
need to upgrade Rep Server as well, or will 12.1 Rep Server
Work with ASE 12.5.
Also, we will be upgrading AIX to 5.1 as well.
Any advice is appreciated.
It will work, however you wont be able to use any of the 12.5 new datatypes,
and the rep_agents will spit out annoying error/warning messages everytime
they are restarted. Our production system has been running that way for
about ye...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 15.0.2
Is it supported? Anyone tries this, if so, could you post the steps and
comments. I don't want to use ECDA (gateway) here, unixODBC driver is
You can't setup a "remote server" to anything other than another ASE, ECDA,
or any other open server product. In order to connect to an ODBC target,
your only option is ECDA.
"dbMethods" <firstname.lastname@example.org> wrote in message
> Is it supported? Anyone tries this, if so, could you post the steps and
> comments. I don't want to use ECDA (gateway)...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...rep server 12.1 and ase 12.5.3 rep agent not starting
Here is the scenario..
-Rep server ver 12.1
-ASE 12.5.3 having
---A. RSSD db
---B. Replicate dbs
Primary databases are on different machines each with ASE
The primary sql server names are the same but the interface
file entry in Machine 1 has different names for each.
ASE server name test1
Rep server name rep1
Interface file entries:
...Rep Server & ASE
Can Rep Server run on the same machine as ASE?
<mike> wrote in message
> Can Rep Server run on the same machine as ASE?
...Rep Server and ASE compatibility!
Can some one help on the following topics.
We have SybaseASE 12.0 and Rep server 12.0 running at 5
sites. One Rep server is designated as ID Server.
Now we want to upgrade to ASE 12.5 and REP server 12.5 at
each site phases say one site in one phase and then second
one in second phase.
Can some one give a plan...?
- Will Repl server 12.0 can communicat with Rep server 12.5
and ASE 12.5 in case one site is upgraded and others are not
- Do we need to upgrade ID server first or other servers ?
Please if someone can help out in this will be highly
obliged....ASE 11.5 on same server as ASE 12.5?
Anyone have 11.5 running on same server as 12.5 on NT?
Would not be concerned to do this in Solaris as I am on an NT 4.0 Box sp6.
Any known gotchas or issues? Going to take toni's advise in earlier posting
on doing the 11.5 install as a seperate user on the server already running
12.5 just fine. Hope this wilkl take care of env vars???
We have one app that the company who developed it will no longer support us
on newer versions of Sybase as a result this one crucial app must stay up
and running on 11.5 while we allow the rest of our company to progress
forward to 12.5 an...Rep Server & ASE
Does anyone know if Rep Server 12.5 requires ASE 12.5? Or can Rep Server
12.5 work with ASE 12.0?
On Fri, 2 May 2003 14:39:10 -0400, mike wrote:
>Does anyone know if Rep Server 12.5 requires ASE 12.5? Or can Rep Server
>12.5 work with ASE 12.0?
I would check the release bulletins for Rep Server to know for sure. I do know
that Rep Server 12.0 works find with ASE 12.5 as long as you aren't using the
longer data types available in 12.5.
Jim Egan [TeamSybase]
We have an instance of the pair(ASE-12_0,REP-12_5) you mentioned below We
have ...Upgrade ASE and Rep Server
It's been a long time since I played with rep server and I just started a
job where next weekend they want to upgrade ASE to 64-bit. My question is
do we have to upgrade both primary and replicate to 64-bit or can replicate
remain 32-bit. Rep server is on the replicated machine.
<NCousin> wrote in message
> It's been a long time since I played with rep server and I just started a
> job where next weekend they want to upgrade ASE to 64-bit. My question is
> do we have to upgrad...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