Conversion From Interbase 5.5 to Interbase 6.0

[Guest_imported]

I'm using Interbase 5.5 currently, and I would like to upgrade to Interbase 6.0.
I understand that my existing database can't be used directly in Interbase 6.0 & i should do the conversion.
What is the steps should be taken for this conversion?
Hope anyone can help. Thanks!!

 

[svanels]

Start IB 5.5 and back-up your databases with the gbak-utility.

Start-up Interbase 6.0 and restore the databases with that version. One advice, I would use 2 different computers to do this. Steven van Els
SAvanEls@cq-link.sr

 

[JuanMah]

Usually i do backup by using the Server Manager, is that what you called "gbak-utility"?

After I've done the 2 steps & check the database has no problem, can I uninstall the IB5.5 in the 1st computer & install IB6.0 then transfer back the database file? Because I need to use back that computer.

Thank you!

 

[JuanMah]

I try to run the program (after the 2 steps) with IB6.0 but come out with this error message :

General SQL Error.
Invalid Token......


This error is the same as I met when I copy the GDB file (IB5.5) & paste it into the 2nd computer(IB6.0).

 

[SamC]

two words for an successfull backup.
first of all select 'Transportable Format' on your 5.5 Server.
restore this backup in your 6.0 server (eventually have to set the 'SQL Dialect' to 1)

check if you've used 'external functions' on your 5.5 database.

greets, Sam

 

[JuanMah]

how do I set the 'SQL Dialect' to 1?

 

[SamC]

if you are using IBConsole to access your data you can define an alias ('Register Database') for your db. there you can choose 'Database Dialect'.

in ddl it's 'SET SQL DIALECT 1'.

what is the way you access your data?

 

[svanels]

Does the IBConsole connect to 5.5? With 5.1 it gives problems. Steven van Els
SAvanEls@cq-link.sr

 

[JuanMah]

Here is the steps that I have taken:
(i) Go to the 1st PC (Interbase 5.5) backup the database by using the server manager. Select Transportable Format only.
(ii) Copy the backup file (.gbk) & paste into the 2nd PC (Interbase 6.0).
(iii) Restore the backup file by using IBConsole. Use the default settings.

What I should do after these steps?


Thanks for helps!

 

[svanels]

Check if you can see the data with Interactive SQL in the IBConsole Steven van Els
SAvanEls@cq-link.sr

 

[JuanMah]

What can I check with the Interactive SQL in IBConsole?

I'm having problem while I try to run the Delphi program which using this database.

 

[svanels]

Now you mention Delphi!!

Did you succeed in upgrading the database? With the interactive sql type in: select * from mytable, and look if data exists.

How does delphi make the connection? BDE, IBXcomponents, etc? and which version of delphi are you using?

Does it work on the older computer? and what are exactly your problems? Steven van Els
SAvanEls@cq-link.sr

 

[JuanMah]

so sorry i din mention delphi, coz this the 1st time i posted msg here...

i was using BDE to make the connection in the 1st PC (Interbase 5.5).

After I hav completed the Backup & Restore from the 1st PC (IB5.5) into the 2nd PC (IB6.0). I try to run the Delphi program and this error message come out:

General SQL Error.
Token Unknown - line 1 char 59 'SECOND'

This error msg would not come out in the 1st PC (IB5.5).

How do I solve this problem? Thank you.

 

[svanels]

I think you have to examine the query that is producing the error. I suspect that the origin is a datetime field type, that has changed in version 6. Post the whole sql-sintaxe that is used in this query.

Regards Steven van Els
SAvanEls@cq-link.sr

 

[JuanMah]

I suspect that the error message comes from the field in a table, which I named it "SECOND" in Interbase 5.5.
But because of Interbase 6.0 use "SECOND" as their reserve keyword, therefore this error msg comes out, is it?

So what I should do? Is it I need to change it myself manually every table or stored procedures that using "SECOND" to another name?

 

[svanels]

You will have to rename that field, that is the best way, or you have to stick with Interbase 5.5

Regards Steven van Els
SAvanEls@cq-link.sr