Hi I have attempted to follow the post on changing the database page size from February 2013.
I am using Sybase ASA 220.127.116.1142.
Step 1 was to create a fresh database using dbinit - p 8k c:\sqlData\NewData\MyData12.db
Step 2 was to use the dbunload command to copy the existing database to the new one with:
dbunload -c "UID=DBA;PWD=sql;DBN=MyData12;DBF=c:\sqlData\MyData12.db" -ar "UID=DBA;PWD=sql;DBN=MyDataNew;DBF=c:\sqlData\NewData\MyData12.db"
This results in SQL Error: Specified database file already exists.
I have tried using the -ac and -an switch both giving the same error.
What have I missed?
I wish to change the existing database 4k page size to 8k page size keeping the same database name and file. Just as in the orignal post with the -ar option, but I can't seem to get it to work.
asked 17 Feb '15, 22:22
When you want to reload into an existing database, you cannot use option "-ar" as that creates a new database by design and replaces the old one. Instead you want to use option "-ac" instead.
If you only want to change the pagesize, you could omit the step to create a new database and could then use something like (untested):
in one step.
Is each DB as follows?
Please try the following command.
dbunload -c "UID=DBA;PWD=sql;SERVER=MyData12;DBF=c:\sqlData\MyData12.db" -ac "UID=DBA;PWD=sql;SERVER=MyDataNew;DBF=c:\sqlData\NewData\MyData12.db" -xx
answered 18 Feb '15, 02:53