Subject | Re: How do I get my database back? |
---|---|
Author | Dmitry Yemanov |
Post date | 2015-03-25T09:52:38Z |
25.03.2015 12:20, Tim Ward wrote:
rather use the -n switch. As a result, you have all data but some
constraints are missing. Then generate the metadata script for the
resulting database, compare it with the original one (yes, you should
have it somewhere in VCS), generate an upgrade script (I suppose
IBExpert is able to create one) and fixup your restored database.
Maybe not a piece of cake and can hardly be automated, but it provides
you with a valid database.
Dmitry
> The fix in 3.0 sounds good! - but it'll be a while for us, we'reInstead of going for the -o switch and losing one table completely, I'd
> currently looking at upgrading to 2.5.
rather use the -n switch. As a result, you have all data but some
constraints are missing. Then generate the metadata script for the
resulting database, compare it with the original one (yes, you should
have it somewhere in VCS), generate an upgrade script (I suppose
IBExpert is able to create one) and fixup your restored database.
Maybe not a piece of cake and can hardly be automated, but it provides
you with a valid database.
Dmitry