I'm converting ASA9 database to SA11.
This database have 4 dbspaces (main +3), after all process, extra dbspace files, have dbR extension.
Is it safe to just rename to .db ?
28 Sep '11, 08:34
28 Sep '11, 08:35
Yes, it is safe to rename the dbspaces to have any name you would like but when you do so you need to also execute an "ALTER DBSPACE RENAME ..." statement for each dbspace to tell the database server the new name of each file.
28 Sep '11, 08:55
Thank you Mark. And can you tell me why file name ends with R?
The dbspaces get assigned an extension of "dbR" so as to not conflict with the original file name's extension (typically "dbs") - in case the new file is in the same directory as the original file - and to make it obvious which files are the new "rebuilt" dbspaces. This is explained in the docs: http://dcx.sybase.com/1201/en/dbadmin/dbunload.html
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
learn more about Markdown
question asked: 28 Sep '11, 08:34
question was seen: 2,199 times
last updated: 28 Sep '11, 14:55
What should I review when I migrate from 9.0.2 to 11.x?
Migration Oracle to ASA9
Should I move asa9 database to sa11 or forward to sa12?
SA9 to SA11 migration: right truncation of string data.
How Do I Upgrade My SQLA database from v9 to v11
Does SQLA 9 support DDL Triggers
Numbers format problem after migrating database
How to Import Tables From SQL Server 2012 Into SQL Anywhere 16
Migrate from ASA8 to ASA12 over a nine month period
SQL Anywhere on Windows operating system changes db file to read only
SQL Anywhere Community Network
Terms of Service
Powered by SQL Anywhere 17
Disclaimer: Opinions expressed here are those of the poster and do not
necessarily reflect the views of the company.
First time here? Check out the FAQ!