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...
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 ...
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
server
- Configure the Cons server for another subscriber
- Configure the new Remote's shared table, publications, &
subscriptions.
- Manually b...
Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.Hi All,
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?
Potential options:
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.5.2 / Functional IndexesWelcome,
Does ASE 12.5.x support functional indexes?
TIA
Best Regards
ViBart
ViBart wrote:
> Welcome,
>
> Does ASE 12.5.x support functional indexes?
>
> TIA
>
> Best Regards
> ViBart
>
>
>
No -- but 15.0 does. 15.0 is currently in beta and expected to be released later this
year.
HTH,
Rob
-------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5
Author of "...
Solaris ASE to Linux ASEWe 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 ?
Hi,
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 asecan 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
http://my.sybase.com/detail?id=1009730
Ian Bater
iAnywhere Solutions
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 ...
Future of ASE
In a recent article
http://www.cbronline.com/content/COMP/magazine/Articles/Features/PowerBase.asp
"Chen's mantra is that the company must be good in every market it operates
in. If it isn't, he either redoubles its efforts or gets out of that space."
So which does Chen plan to do with ASE? Perhaps he'll address this at
TechWave?
Sounds like Jack Welsh @ GE. He sold off small appliances which everyone
said he should not do because thay were the identity of the company.
"Carl Kayser" <kayser_c@bls.gov> wrote in message
news:42e...
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...
sql-remote between ASE and ASEhello!
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 ,
...
ASE workgrouphi,
what the diference between ASE workgroup and ASE Enterprise, to which
systems apply workgroup or enterprise.
is an AlphaServer 4000 (DIGITAL SERVER 7305) workgroup and unix
and ASE 12.0 will be avaliable for true unix (DEC UNIX).
thanks in advance
...
SQL Remote ASEhi
did anybody know when SQL Remote support blob (image, text) replicacion for
ASE - ASE?
our company need this feature.
joan caceres
electro sur este s.a.a.
Hello Joan,
Support for image and text replication with SQL Remote went in as of ASA 6
mainline, 6.0.01.1256,
and SA maintenance 5.5.04 build 1938.
Regards,
Bob Bauer
Sybase Technical Support
jmcd wrote:
> hi
>
> did anybody know when SQL Remote support blob (image, text) replicacion for
> ASE - ASE?
>
> our company need this feature.
>
> joan caceres
> electro sur este ...
ASE Migration From ASE 11.5.1 (NT) to ASE 12.9 on Win2003.Need help to find Sybase's upgrade and migration docs on
above subject?
Thank you.
ASE 12.9? Currently, no released versions of ASE are certified on Win 2003.
ASE 12.5.1 will be certified when it is released later this year.
Mark Kusma
<Lily Maria> wrote in message news:3f497cad.367e.846930886@sybase.com...
> Need help to find Sybase's upgrade and migration docs on
> above subject?
> Thank you.
Thanks for the info.
I would like to know if there's any online documentation on
migration and upgrade plan of the ASE 11.5.1 to ASE 12.5.1?
Do applica...