Sybase - Backup and restore db into other server

Hi guys,

I'm on my plan to do backup of sybase 15.0 from Solaris and restore it on Linux Centos machine.

Beside having the backups  of the db which is around 100GB data size, I'm thinking as well to copy all users from current server and create it in new Linux machine, ut I have no idea how to copy login and create in new sybase.

Upon restored the db, I need to run the statistic and checkstorage, please let me know the command of doing that.

Any recommendation what are the require for me t complete this database migration
motioneyeAsked:
Who is Participating?
 
alpmoonConnect With a Mentor Commented:
I am sorry for telling that, but it is not just a simple dump and load. There are certain steps you need to achieve that migration.

First of all you need to set database in single user mode, run sp_flushstats and wait for pages to be flushed (it is better to run a checkpoint as well) before dumping the database.  Otherwise it cannot be loaded into a Linux server. Also load will take 2-3 times longer due to conversion and reindex. Even after that you may need to drop and recreate some indexes. Actually they all depend on whether your Solaris is on an intell machine or not.

Check that document before doing anything: http://www.sybase.com/content/1033627/18XPDL_1253_WP.pdf

You can bcp out syslogins and load it into your Linux ASE server. But be very careful, don't include system logins (sa, probe etc.) and don't delete them in target server. Don't try it if you do not feel comfortable with syslogins.
0
All Courses

From novice to tech pro — start learning today.