| Subject | Re: Restore on firebird 2.0.3 from |
|---|---|
| Author | tomkrej |
| Post date | 2008-02-07T09:02:24Z |
We had to migrate our databases from IB6 to FB1.5, and we did it in
this way.
1. we extract DDL definitions of all TRIGGERS, STORED PROCEDURES and
VIEWS into SQL script file (using ibexpert).
2. we drop all these objects in IB database copy.
3. we back up copy of IB database
4. we restore this copy on FB server.
5. we run sql scripts with views, procs a triggers on FB1.5 and
correct the differences between IB and FB DDL
Tom
this way.
1. we extract DDL definitions of all TRIGGERS, STORED PROCEDURES and
VIEWS into SQL script file (using ibexpert).
2. we drop all these objects in IB database copy.
3. we back up copy of IB database
4. we restore this copy on FB server.
5. we run sql scripts with views, procs a triggers on FB1.5 and
correct the differences between IB and FB DDL
Tom
>I'm
> The problem is actually inside BLR for some procedure/trigger/view.
> InterBase is known to generate invalid binary code in some cases. So
> afraid this database will never restore on FB.
>
>
> Dmitry
>