How to change page size in an existing sybase database I have an existing database with 1 kb page size i want to increase that to 16kb and increase cache to take advantage of my memory for best performance. sybase documentations said you can't change page size of database but you can create new empty database with preferred page size, so how can i move my data to from old db to new database with big page size ?
Take a look at the dbunload utility, particularly the -an and -ap switches. You didn't say what version you are using, but here are the docs on v12.0.1.