| Subject | Re: How to convert Firebird1.5 Dialect1 to Firebird2.0 Dialect3? |
|---|---|
| Author | Adam |
| Post date | 2007-03-18T22:44:11Z |
--- In firebird-support@yahoogroups.com, "Adrian Wreyford"
<wreymed@...> wrote:
have not seen that before.
Maybe a data pump would work?
Create the Dialect 3 structure in FB 1.5, then data pump it from your
Dialect 1 database to Dialect 3. I have used IBDatapump from
CleverComponents which has worked well for me, but there are also
other similar applications, take your pick.
After you have a working 1.5 in dialect 3, simply backup using gbak
then install Firebird 2 and restore the backup.
Adam
<wreymed@...> wrote:
>round
> Hi
>
>
>
> Any pointers of how to go about converting Firebird1.5 database with
> Dialect1 to Firebird2.0 database with Dialect3?
>
>
>
> I need to keep the Numeric(18,2) as Numeric(18,2)
>
>
>
> If I backup in Firebird1.5, then restore in Firebird2.0, then all
> Numeric(18,2) change to Integer fields, but still handle data correctly.
>
> However newly created integer fields don't hold nr's like 5.26, they
> them off to 5.Hmmm, that doesn't seem right. Maybe it is a bug or a known gotcha. I
>
have not seen that before.
Maybe a data pump would work?
Create the Dialect 3 structure in FB 1.5, then data pump it from your
Dialect 1 database to Dialect 3. I have used IBDatapump from
CleverComponents which has worked well for me, but there are also
other similar applications, take your pick.
After you have a working 1.5 in dialect 3, simply backup using gbak
then install Firebird 2 and restore the backup.
Adam