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 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...Upgrade Problems (ASE 15.02 ESD#5 to ASE 15.03)
I recently tried to upgrade to ASE 15.03. Downloaded the
file ase1503_linx86_32.tgz via wget from the product
download center, gunzip'ed it into a directory and tried to
./setup -console it.
During the setup script I got presented with the following
java.io.IOException: Cannot run program "rpm":
java.io.IOException: error=2, No such file or directory
at java.lang.ProcessBuilder.start(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
com.s...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...Loading a DB Dump from an ASE 12.5.3 load into ASE 15 remaps TABLE ID's but causes issues for Procedures
When we load a dump of our database, from our ASE 12.5.3
server into our ASE 15 (same sizes, options etc), we find
that the table_ID's are different(newly created), but no
mapping exist to the old table id's used.
So the newly migrated procedures that depend on these tables
and still seem to reference the old table ID's somewhere,
fail unless entirely dropped and recreated.
SP_RECOMPILE does NOT help! They problem persists.
It fails when executed and we can't necessarily recompile
Any ideas, please let me know
> When...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: 126.96.36.199: Database xxxxxxxxx: 655484
kilobytes (58%) LOADed.
Jun 09 12:31:20 2006: Backup Server: 188.8.131.52: LOAD is complete (database
...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...Why does the following query fail on ASE 15.0.2 but work on ASE 12.5.4?
Connection conn = getConnection();
PreparedStatement stmt = conn.prepareStatement("select 'test' from
syscolumns where ? = ?");
The error is "Implicit conversion from datatype 'VARCHAR' to 'INT' is not
allowed. Use the CONVERT function to run this query."
I think I found the solution, which is that the database needs to know what
type to expect for the parameter marker. Therefore using an explicit
conversion (as mentioned in the error me...ASE 15 on Debian Etch WAS: ASE 15 on Debian 3.1 sarge install problem (Jul 26,2007)
> Still no response? Anybody knows what to do with glibc to
> have tls support?
> P.S. I tried upgrade to last kernel (http://www.kernel.org
> 184.108.40.206), but I ended with kernel panic unable to find
> what=b4s wrong... Now I=b4m tr trying download Debian
So, in the end I downloaded Debian 4.0 Etch installed it in
VMWare Player (under Windows XP Home) installed Sybase 15.0
EE and everything is O.K. :))))
> > Still no response? Anybody knows what to do with glibc
> > to have tls support?
...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 12.5.2 and ASE 15
We have a Sun Solaris server with ASE 12.5.2. Can we install
ASE 15.0 on this server and work with two version of ASE ??.
<George> wrote in message news:email@example.com...
> Hi everybody:
> We have a Sun Solaris server with ASE 12.5.2. Can we install
> ASE 15.0 on this server and work with two version of ASE ??.
Yes -- as long as you install each in a separate directory tree and make
sure you have separate sets of settings for $SYBASE, $SYBASE_ASE<
$SYBASE_O...Loading a 15.5 dump into ASE 15.0.3
I'm trying to insert 30 GB into an existing table in an ASE
15.0.3 database as fast as possible. I want to try using
'insert .. select from ' into a ASE 15.5 minimally logged
database, dump the database and load it into an ASE 15.0.3
Does anyone know I can do the load and will it be faster
than a slow bcp?
Thanks in advance.
Le 18/06/2010 16:14, Andrei R. a �crit :
> I'm trying to insert 30 GB into an existing table in an ASE
> 15.0.3 database as fast as possible. I want to try using
> 'insert .. select from ' into...Are there any common errors / issues related to using the dump/load strategy vs. sqlupgrade utility for upgrade/migration to ASE 15.x (from ASE 12.5.x)?
Are there any common errors / issues related to using the
dump/load strategy vs. sqlupgrade utility for
upgrade/migration to ASE 15.x (from ASE 12.5.x)?
I've been reading posts on this discussion thread to try to
see if I can find any disadvantage of using the dump/load
strategy vs. using the sqlupgrade utility (i.e. common
errors / issues).
I noticed that some have run into errors after the
upgrade/migration when using system stored procedure(s). So
this sparked a few questions...
1) Is one upgrade/migration strategy prone to more errors
and issues than ...ASE 12.5.2 to ASE 15 Migration
I have a master database with size of 10 MB. When I run preupgrd.exe to
check the upgrade validation, exe fails with a note add atleast 7 MB of
additional data space !!
Its known fact master db cannot grow out of master device, the left option
takes both data and log when I use alter database. I re-checked preupgrd.exe
to validate the upgrade process again its giving same message (I altered
master database to the maximum of 40M from 10 MB)
***ERROR: alter database master to add at least 7 MB of data
***ERROR: alter database tempdb to ad...Different behaviour of syslogins in ASE 15 and ASE 12.5?
I figured out a different behaviour if I create a login with more than 30 charaters as fullname, for example:
sp_addlogin heinz, password, null, null, "these are more than 30 characters I think"
In ASE 12.5 the account is created but the fullname column cropped after 30 characters.
In ASE 15.0.2 the account isn't created at all.
Anyone know if this a feature of 15.0.2? Any parameters I can set to get the 12.5.x behaviour?
I'm gonna assume you issued this command via some GUI ... because when I issue the command via isql I get: