ASE to Rep Server to Rep Server to ASE ConfigurationHello
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 11.9.2 -> ASE 12.5 Migration over Replication Server?Hi,
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.
Best regards,
Marco Stroech
______________________________________________________
Marco Stroech
Databases
AOL Deutschland � Millerntorplatz 1 � 20359 Hamburg � Germany
+49 (40) 36159-7454 � fax: +49 (40...
Replication between ASE 11.9.2 without Rep. Server ?
Hi,
I like to set up the replication from one Masterdatabase to several
Searchdatabases, all 11.9.2 under Linux and connected with LAN. The
inserts and updates shout go manual or automatical to the
Masterdatabase.
Need I a Replication Server in this situation ?
If no, what is the right way to configure a soulution ?
If I use a Replication Server, for example under NT, what are the
benefits ?
By
Joachim
...
Replication between ASE 11.9.2 without Rep. Server ?Hi,
I like to set up the replication from one Masterdatabase to several
Searchdatabases, all 11.9.2 under Linux and connected with LAN. The
inserts and updates shout go manual or automatical to the
Masterdatabase.
Need I a Replication Server in this situation ?
If no, what is the right way to configure a soulution ?
If I use a Replication Server, for example under NT, what are the
benefits ?
By
Joachim
Hi Joachim,
You can use SQL Remote, which is included with ASE 11.9.2,
to do replication. However, it's not an instant setup, and
it is not appropriate for conti...
Replication from ASE 11.92 and Rep 11.5 on AIX 4.2.1 to Linux ASE 11.92 possible?We are trying to work this out and so far have hit a few snags. Here is the
situation:
Our Linux server is named tlaas_linux1 and our AIX server is ZYDVAX01. The
ASE servers are named tlaas_linux1_sy and ZYDVAX01_SY respectively.
from tlaas_linux1:
-isql -Usa -Ppassword -SZYDVAX01_SY (works)
-exec ZYDVAX01_SY.master..sp_who (works)
from zydvax01:
-isql -Umaintuser -Pmaintpass -Stlaas_linux1_sy (works)
-isql -Usa -Ppassword -Stlaas_linux1_sy (works)
-exec tlaas_linux1_sy.master..sp_who (works when logged into
ZYDVAX01_SY.mzypd using isql)
-stored procs in the replicate database...
ASE 15.0.2Is 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
preferred.
Thanks
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" <dbmethods@nospam.com> wrote in message
news:47e19f5a@forums-1-dub...
> Is it supported? Anyone tries this, if so, could you post the steps and
> comments. I don't want to use ECDA (gateway)...
ASE to ASEHi,
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
replication?
Thanks in advance
Doug Trainer
Hi Douglas,
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
ASE11.5.
I will be happy to...
ASE and ASECould it be possible to take scripts from ASA and load them in an ASE
Any information is welcome
jean-fran�ois
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...
2-way Replication between ASE and SQL AnywhereHi All,
We have a 2-way Replication setup between ASE 11.9.2 and SQL Anywhere
5.5.05 with replication server 11.5.1.
Now we want to use ASE 12.0
Does this need changes in the versions of RS,SQL Anywhere, OSG for SQL
Anywhere or LTM for SQL Anywhere.
Waiting anxiously for help.
Thanks and Regards,
Shyju.
...
2-way Replication between ASE and SQL AnywhereHi All,
We have a 2-way Replication setup between ASE 11.9.2 and SQL Anywhere
5.5.05 with replication server 11.5.1.
Now we want to use ASE 12.0
Does this need changes in the versions of RS,SQL Anywhere, OSG for SQL
Anywhere or LTM for SQL Anywhere.
Waiting anxiously for help.
Thanks and Regards,
Shyju.
...
Rep. Server 11.0.2 with ASE?Hi,
I have RS 11.0.2 running on HP-UX 10 and SQLServer 11.0.2. I am
thinking of upgrading
Sybase to 11.5 ASE.
Does anyone know of any incompatibility problems with running 11.5 ASE
with RS 11.0.x?
THanks for your help!
> I have RS 11.0.2 running on HP-UX 10 and SQLServer 11.0.2. I am
> thinking of upgrading
> Sybase to 11.5 ASE.
> Does anyone know of any incompatibility problems with running 11.5 ASE
> with RS 11.0.x?
No problems. We are running hp-ux 10.20 with RS 11.0.2 and ase 11.5.
You may want to upgrade to the latest open client/server (11.1.1) ...
Replication between ASE and ASE URGENTHI everybody
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
available.
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
feasible ???
Thanks four your answer
"Marco" <mbarrion@uniplex.com.ec> wr...
ASE 12.0.0.6 to ASE 12.5 and Rep Server 12.1We are planning the upgrade of our ASE 12.0.0.6 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.
Thanks,
Troy
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 - VSWhat 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.
--
David Fishburn
Sybase
Please only post to the newsgroup
BH Ong <bhong@tm.net.my> wrote in message
news:01bf4b98$33183580$7ccdc8c8@virtual-branch...
> What are the differents in terms of configuring SQL Remote Between ASA to
> ASE and ASE To ASE ...