Subject Re: [firebird-support] Restore problem 2.1 to 2.5
Author Helen Borrie
At 09:12 p.m. 15/03/2013, Lester Caine wrote:
>I know I've seen this but can't find a reference ...
>
>AH found http://tracker.firebirdsql.org/browse/CORE-3121 now and
>http://firebird.1100200.n4.nabble.com/Error-Restoring-v2-1-Database-to-v2-5-td2994314.html
>
>
>I don't remember backing up this particular site BACK to 2.1 but it is always
>possible. There are a few things which broke moving to 2.5 and the reason for
>moving up now is to test prior to updating on site. So is all that is needed to
>delete RDB$ADMIN from the 2.1 version prior to backing up?

Yes, just
DROP ROLE RDB$ADMIN

Won't work in 2.5.x, of course! ;-)


Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.ibphoenix.com/products/books/firebird_book
__________________________________________________________________