| Subject | Re: [IB-Conversions] Interbase 5.6 to Firebird 1.5.4 migration |
|---|---|
| Author | Helen Borrie |
| Post date | 2007-08-28T09:12:01Z |
At 03:32 PM 28/08/2007, you wrote:
since the changes that affect you are not IB-to-Firebird, but the
significant changes that occurred at that transition. You will need
to understand the difference between "dialect 1" SQL (IB 5.6 and
below) and "dialect 3".
Here is a page where you can find a link to this guide. Scroll down
almost to the bottom of the page and RIGHT-CLICK on the link as that
site is not MIME-aware for browsers.
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_interbase_download
Pay close attention to the information about data types. The DATE
type has changed (dialect 1 DATE is dialect 3 TIMESTAMP and dialect 3
DATE is date-only). Storage of double precision numbers with
precision > 9 has changed, which will affect any DP numbers you have stored.
Watch UDF declarations. UDFs have had a lot of cleanup and Firebird
is stricter than InterBase about access security for UDF
libraries. Ask on the firebird-support list if you bump into problems.
For keywords, consult the release notes of the version of Firebird
you plan to move to.
As far as SQL language is concerned, you might have some corrections
to do in client code, as Fb 1.5.4 is less tolerant of bad syntax than
IB 5.6 is. The 1.5.4 release notes contain all of the language
enhancements for Fb 1.0.x and 1.5.x.
If you have to convert existing databases, bring them up to ODS 10.1
by backing them up under the IB 5.6 server using gbak with the
-transportable switch. Then restore them under the Fb 1.5.4 server,
specifying a page_size of 4096 or 8192. This will give you a dialect
1 database with on-disk structure v. 10.1.
Don't overlook the archive of this list as a source of information
about the migration from IB 5.6.
Helen
>Hello Friends,Your best starting place would be the InterBase 6 Migration Guide,
>
>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 script
>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)?
since the changes that affect you are not IB-to-Firebird, but the
significant changes that occurred at that transition. You will need
to understand the difference between "dialect 1" SQL (IB 5.6 and
below) and "dialect 3".
Here is a page where you can find a link to this guide. Scroll down
almost to the bottom of the page and RIGHT-CLICK on the link as that
site is not MIME-aware for browsers.
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_interbase_download
Pay close attention to the information about data types. The DATE
type has changed (dialect 1 DATE is dialect 3 TIMESTAMP and dialect 3
DATE is date-only). Storage of double precision numbers with
precision > 9 has changed, which will affect any DP numbers you have stored.
Watch UDF declarations. UDFs have had a lot of cleanup and Firebird
is stricter than InterBase about access security for UDF
libraries. Ask on the firebird-support list if you bump into problems.
For keywords, consult the release notes of the version of Firebird
you plan to move to.
As far as SQL language is concerned, you might have some corrections
to do in client code, as Fb 1.5.4 is less tolerant of bad syntax than
IB 5.6 is. The 1.5.4 release notes contain all of the language
enhancements for Fb 1.0.x and 1.5.x.
If you have to convert existing databases, bring them up to ODS 10.1
by backing them up under the IB 5.6 server using gbak with the
-transportable switch. Then restore them under the Fb 1.5.4 server,
specifying a page_size of 4096 or 8192. This will give you a dialect
1 database with on-disk structure v. 10.1.
Don't overlook the archive of this list as a source of information
about the migration from IB 5.6.
Helen