Subject Re: [firebird-support] Migration Strategy IB5.6->FB1.0
Author Tom Conlon
Is it true that 5.6 gdb (ODS 9.1?) is compatible with FB1.0?

In other words is a server upgrade *only* ok in the short term or is it ill
advised?
(If so, then upgrade of server and all clients is only option.)

Lastly, in worst case (assuming dialiect 1, no field name issues) is a
transportable backup via FB1.0 restorable *back to* IB5.6?


Tom

----- Original Message -----
From: "Florian Hector" <FHector@...>
To: "IB-Support" <firebird-support@yahoogroups.com>
Sent: Sunday, December 28, 2003 7:36 PM
Subject: Re: [firebird-support] Migration Strategy IB5.6->FB1.0


> > Has anyone important pointers/tips to give in making this a smooth
> > transistion. Ideally a Disaster Recovery/Rollback plan would be
appreciated
> > even though this should not be required.
> >
> > The main question is regarding ODS version compatibility + server/client
> > compatabilities.
> >
>
> The usual:
> Make a backup of the DB using IB 5.6, to play it safe with transportable
format switched on. Then
> you make a restore using FB. The thing you have to check prior to using
the db in production is
> ambigous fieldnames:
> When you have a joined dataset with a fieldname which exists in more than
one table, IB didn't care
> but FB does. So you have to qualify the fieldname.
> E.g you had a query like this:
>
> Select CustID, Customer, Address
> from Customer
> join Address on Customer.CustID=Address.CustID
>
> Now, CustID exists in both tables, FB doesn't know which one to use. You
have to change it into
>
> Select Customer.CustID, ....
>
>
> Florian
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>