I have become a huge fan of dbunload -an for upgrading a database in one fell swoop... the days of reloads collapsing in a heap seem to be behind us.
It would be nice to say "This upgrade process leaves the existing database untouched" and I'm sure it does... except the file timestamp changes for the old.db and log files.
There doesn't seem to be any dbunload equivalent for the dbeng.exe -r option... what am I missing?
I realize that a database in need of recovery can't be unloaded in read-only mode, that's outside the scope of this question.
And yes, the old-school three-step-process dbunload-dbinit-reload could make use of dbeng -r, but that's not as much fun as dbunload -an.
asked 05 Aug '13, 16:40
As part of the connection string you can pass database switches (DBS) that apply to an autostarted database.
Since the -r switch can be either a server switch or database switch, it can be passed to start that database as read-only even if other aspects of the server are not.
answered 05 Aug '13, 16:54