Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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 ?

asked 28 Sep '11, 08:34

Zote's gravatar image

accept rate: 43%

edited 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.

permanent link

answered 28 Sep '11, 08:55

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

Thank you Mark. And can you tell me why file name ends with R?

(28 Sep '11, 14:45) Zote
Replies hidden

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:

(28 Sep '11, 14:55) Mark Culp
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 28 Sep '11, 08:34

question was seen: 3,915 times

last updated: 28 Sep '11, 14:55