Subject | Re: [firebird-support] Migration Strategy IB5.6->FB1.0 |
---|---|
Author | Florian Hector |
Post date | 2003-12-28T19:36:08Z |
> Has anyone important pointers/tips to give in making this a smoothThe usual:
> 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.
>
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