Subject Re: How to upgrade a FB database internal tables
Author venussoftop
Thanks Martijn. I tried that unfortunately I am getting an error that BLOB_ID is invalid. Screen details of the error below followed by the command I had used:

...
gbak: writing data for table BCA3
gbak:0 records written
gbak: writing data for table BEA3
gbak:0 records written
gbak: writing data for table TEA3
gbak: ERROR:invalid BLOB ID
gbak: ERROR: gds_$receive failed
gbak:Exiting before completion due to errors

C:\>"c:\program files\firebird\firebird_2_1\bin\gbak.exe
" -B -V -T -USER myuser -PASSWORD mypswd old.fdb old.fbk

Please advise

Thanks.


--- In firebird-support@yahoogroups.com, "Martijn Tonies" <m.tonies@...> wrote:
>
> Hi,
>
> > I need to upgrade a database from 1.5/2.0(?) (having 32 system tables) to
> > 2.1.3.18185 (having 40 system tables). On my test machine I had to obtain
> > a blank 2.1.3 database and pump data from the old database. Is there any
> > easier way to do so? Any command line option in FB itself that does this.
> > I am hoping for a way to automate this which can be useful when I switch
> > to 2.5 maybe also.
> >
>
> Create a backup, restore it in the new server, presto: database upgraded.
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>