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 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...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 ...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
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.
<Lily Maria> wrote in message news:email@example.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...Dump from NT ASE 11.5 to NT ASE 11.5.1
I am having trouble dumping a 11.5 ASE database to a 11.5.1 backupserver. I
have the remote backupserver listed in the 11.5 remote servers list. It
works going from the 11.5.1 machine to the 11.5 machine. Is there a
Thank you for your time.
What do you mean by 'having trouble'? Are you getting error messages? If so,
what error messages? Any error messages in the backupserver errorlog?
Is the dump command hanging? not completing? What is the actual dump command
that you're using?
Does the target tape/director...migrate ase nt to ase linux
what is the fastest way to do the data transfer ? is there any specify data
folders like in mysql that i can just copy over?
Dump and load the database.
> what is the fastest way to do the data transfer ? is there any specify data
> folders like in mysql that i can just copy over?
...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...Passwords migration from ASE on NT to ASE on Unix
We are migrating our ASE servers from NT to Unix and trying to keep the
logins and passwords, but it seems like is not posible across platforms
(from NT to Unix). I was able to copy the syslogins data from a NT ASE
server to another ASE NT server, but when I tried from Nt to Unix didn't
Does someone know if there is a way to do it?
No, the encryption is different on the two platforms.
> We are migrating our ASE servers from NT to Unix and trying to keep the
> logins and passwords, but it seems like is not posible across...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...Converting NT 11.5 ASE to a Solaris 12.5 ASE
We are trying to migrate a server running on Windows NT to a Solaris
machine. The NT box is running ASE 11.5 and the Solaris box is running
12.5. So far, the only way we have came up with to migrate the data is bcp.
The problem is we estimate this to be probably about a 6-7 hour process.
Our shop runs 24*7*365 and unfortunately downtime is not something we get.
In the past when we have migrated servers, we have used warm-standby which
has worked really nicely. But in this case we can't run dump and load to
populate the database.
Has anyone been able to migrate an NT box to a...Dump & Load (DB Migration from ASE 12.5 to ASE 15)
What are the important points we need to take care while performing Dump &
Load Migrations from Windows to Linux.
We need to ensure logins, users, roles, and device fragments. Pleaes let me
have expert views.
Does Linux supports RAW Devices ?
> Dear All,
> What are the important points we need to take care while performing Dump &
> Load Migrations from Windows to Linux.
> We need to ensure logins, users, roles, and device fragments. Pleaes let me
> have expert views.
In the past, I've bcp...problems loading ASE 12.5 dump into ASE 15.0 DB
I'm having problems loading a 12.5 database dump into a 15.0 database.
On the 12.5 database I do the following:
dump database xxxxxx to "c:\temp\xxxxxxxxx.bkp"
Then on the 15.0 database I load the database:
load database xxxxxx from "c:\temp\xxxxxxxxx.bkp"
The first strange thing here is the following:
Jun 09 12:31:19 2006: Backup Server: 22.214.171.124: Database xxxxxxxxx: 655484
kilobytes (58%) LOADed.
Jun 09 12:31:20 2006: Backup Server: 126.96.36.199: LOAD is complete (database
...rep solaris ase 11.5.1 to nt ase 11.5/11.51
I need to replicate 11.5.1 ase on Solaris 2.6 to ase 11.5 or 11.5.1 on nt
on intel. Could you answer the following:
1) To move the initial data I would like to load the dump data from the
Solaris server to Windows nt server. Can this be done?
2) Do my device definitions on the Nt side need to duplicate those on the
3) The repserver is on Solaris as well. I only have 11.5 on nt can get ase
11.5.1 on nt. Is this an issue. Do I need repserver on nt?
Any known traps?
> I need to replicate 11.5.1 ase on Solaris 2.6 to ase...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 ...