Search code examples
sybasesap-asepage-size

How to change Sybase ASE page size and charset?


I've a Sybase ASE server that has 2k page size and the charset is roman8.
I want to change it to a 8k page sizeserver with charset utf8.

Is it possibler to do it without migrating the data to a new server?
If so, what are the commands?


Solution

  • To change page size, the only option is to migrate data to a new database either with sybmigrate available in your ASE installation ($HOME/ASE-15_0/bin/sybmigrate) or by bcp in/out all your tables to the new database.