Subject | RE: [firebird-support] Change owner or pump data to new DB |
---|---|
Author | Alan McDonald |
Post date | 2009-09-22T13:53:57Z |
> Hi,if yo backup as SYSDBA, you can restore as the original OWNER. Have you
>
> An client of mine wanted to upgrade to FB 2.1. Now in order to upgrade
> ODS he needs to do backup / restore and this fails with "gbak:
> ERROR:Unable to perform operation. You must be either SYSDBA or owner
> of the database" error. It seems that at some point he has made backup
> / restore as SYSDBA, not as the original owner of the DB... how to fix
> this?
>
> I wanted to pump data into new DB which has correct owner for all the
> objects etc, but the IB Datapump ver 3.4 doesn't work with FB 2.1 -
> when starting pump:
>
created more objects as SYSDBA since the restore?
Clever Components has a datapump
Otherwise you can ask Thomas Steinmaurer for his Owner migrator tool.
Alan