Subject | Re: Interbase 5.6 to Firebird 1.5.4 migration |
---|---|
Author | amoradell |
Post date | 2007-08-28T19:43:56Z |
Hello,
- Stay with dialect 1 (ib 5.6 only choice), otherwise, its better to
create a sql script in dialect3 and use a datapump app (like ibpump)
between the two databases.
- TYPE keyword is reserved in Firebird, so if you have a field named
TYPE, rename it before conversion. Maybe others.
- Change double quotes to simple because Firebird use them with table
names, fields, etc...
- UDF have to be moved to UDF directory, not BIN directory (as in IB
5.6)
- External files : beware of location because Firebird restrict
access (see firebird.conf)
Regards
Alexandre
--- In IB-Conversions@yahoogroups.com, "muralivm"
<muralim_firebird@...> wrote:
- Stay with dialect 1 (ib 5.6 only choice), otherwise, its better to
create a sql script in dialect3 and use a datapump app (like ibpump)
between the two databases.
- TYPE keyword is reserved in Firebird, so if you have a field named
TYPE, rename it before conversion. Maybe others.
- Change double quotes to simple because Firebird use them with table
names, fields, etc...
- UDF have to be moved to UDF directory, not BIN directory (as in IB
5.6)
- External files : beware of location because Firebird restrict
access (see firebird.conf)
Regards
Alexandre
--- In IB-Conversions@yahoogroups.com, "muralivm"
<muralim_firebird@...> wrote:
>script
> Hello Friends,
>
> We are migrating the product from Interbase 5.6 to Firebird 1.5.4
> version. As part of this migration activity, we are running the
> scripts on freshly installed Firebird database to findout the
> errors and rectify it.
>
> Can anyone help me out in getting the unsupported information (by
> this I mean, Keywords, Functions, DDL Statements, DML Statements,
> Operators which are supported in Interbase 5.6, but ceased to
> support in Firebird 1.5.4)?
>
> This would help me a lot in ensuring that this activity is 100%
> error free.
>
> Thanks in advance,
>
> Regards,
>
> Murali M
>