asked on 4/4/2004

Easy way of changing page size

I have very little experience with Sybase. We need a database with 8K page size. but our server is already build with 2k page and there are over twenty existing databases running on the server.

I need options on what's the easiest way to get my new database with 8K page size.

Thanks!

Sybase Database

Last Comment

kennethxu

4/6/2004

SOLUTION

namasi_navaretnam

4/4/2004

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

kennethxu

4/4/2004

ASKER

I would apprecate if you can elaborate it. I'm creating a new database. why do I need to migrate?

namasi_navaretnam

4/5/2004

Well, I do not have 12.5.1 yet. So I am not sure if you have databases that use different pagesizes in the same server?

kennethxu

4/5/2004

ASKER

all other database uses 2k pages, they are updated from old version. I need a new database with 8K page size on the same server. reason being:
1. I need to store records longer then 2K bytes.
2. I'm not sure if the index limit has anything to do withit (I have another Q for that);

So I need to know what's the easiest way of getting the new database on the server.
I appreciate your help so far namasi.

anybody have 12.5 please comment.

ASKER CERTIFIED SOLUTION

alpmoon

4/6/2004

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

kennethxu

4/6/2004

ASKER

thanks for the help. alpmoon, any idea of this one:
https://www.experts-exchange.com/questions/20942982/600-bytes-composite-index-limit.html