we have a sybase 11 database and currently we are planning to upgrade that to latest sybase 15. Can i restore sybase 11 database in sybase 15 or do we have any migration tools that will help the data migration from sybase 11 to sybase 15.
If it were an upgrade from 15_x to another 15_x more recent, you didn't have to do anything special.
Since it's a previous version (11), you will have to use "sqlupgraderes" tool. That tool will help you with migration. Take a look at the installation guide for ASE 15. There is a section there for upgrades.
The version 15 bring new algorithims for the optimizer, for instance queries with the group by on version 15 are not ordered like before due to the choosen algorithm. There are more details to take in consideration when upgrading.
Also you didn't mencioned the OS that you're using, on the manual choose the one that suits you.
Go to SyBooks Online
and choose "Adaptive server 15" and then the installation guide for your OS.
We are using windows XP.We dont have sybase 15 installed right now.since there is no support for sybase 11 we are planning to migrate to sybase 15.So i have to give the migration plans.What exactly the tool "sqlupgraderes" will do.Is this a sybase product or do we need to purchase this tool for migration
From what i understood from the manual, if your version is 11.9, you dont need to make the 2 steps, you can upgrade directly for 15.
Regarding your question, i'm not completly sure, but i don't think is necessary to have another license for ase 12, you can use the evaluate version, since its only for transition. (don't know if some parameters like number of devices, and total size of db will work with this version,etc, but i think they will).