Upgrading SQL Remote: How to use DBUNLOAD -ar and change database options like blank padding?

I'm about to upgrading an ASA 8.0.3 SQL Remote setup to SA 11.0.1 (and testwise to SA 12 RC1).

The old database uses some CREATE DATABASE options I would like to change in the new one, e.g. to turn

blank padding off
ase compatible off
checksum on.

As the database is involved in replication, I would like to use the easy way by DBUNLOAD -ar. However, this seems to make me unable to change the above settings as DBUNLOAD does not support to change these options - and lateron it's too late, as they must be specified at database creation time.

Question:

Do I have to use the "unload process with manual intervention", i.e. with dblog -x -z, or is there a further alternative to change these options? (Not that the manual process would not be feasible.)

sql-remote create-database dbunload

asked 23 Jun '10, 09:57

Volker Barth
40.2k●361●550●822
accept rate: 34%

flat view

One Answer:

active answers oldest answers newest answers popular answers

You cannot change any of the database settings when using the dbunload -ar or -an switch since the new database is created (by dbunload) with the exact same attributes as the original. There are some exceptions to this rule. For example you can change the encryption of the database and the page size of the rebuilt database.

Therefore if you want to change the settings that you have listed, you must use the manual process.

permanent link

answered 23 Jun '10, 13:08

Mark Culp
24.9k●10●141●297
accept rate: 41%

Thanks for the confirmation! In the end, this is not a real limitation in my case, as I will have to use the manual process in order to achieve further changes, e.g. naming check constraints and other stuff not possible wie ASA 8...

(23 Jun '10, 13:29) Volker Barth

By the way, in SA 12 RC1, CHECKSUM ON seems to be the default for CREATE DATABASE (which is fine to me) - in contrast to the docs. Haven't checked with 11.0.1 yet.

(23 Jun '10, 13:41) Volker Barth

Yes, the docs were a little behind with the s/w changes at the time we released RC1. We have decided to turn checksums on by default because there are many advantages and not a lot of disadvantages. The GA docs will have the required changes. Note also that in GA even if the database was created with CHECKSUM ON you will be able to turn checksums off by running ALTER DATABASE CHECKSUM OFF but then you will not be able to turn checksums back on without rebuilding the database.

(23 Jun '10, 13:50) Mark Culp

I welcome that change - Breck's statement that you guys tend to use sensible defaults (in my words) continues to be right:)

(23 Jun '10, 14:28) Volker Barth

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "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

learn more about Markdown

Question tags:

sql-remote ×103
dbunload ×52
create-database ×9

question asked: 23 Jun '10, 09:57

question was seen: 2,515 times

last updated: 23 Jun '10, 13:08

SAP SQL Anywhere

Upgrading SQL Remote: How to use DBUNLOAD -ar and change database options like blank padding?

Follow this question

Related questions