Subject | Re: [firebird-support] Restoring backup from 2.5 to 2.1 |
---|---|
Author | Milan Babuskov |
Post date | 2012-07-06T10:26:32Z |
Aldo Caruso wrote:
need to move from 2.5 back to 2.1, the only way would be to copy data
from one database into another. I tried this in the past and met with
another problem: which version to use to access the databases for copy.
IIRC, 2.5 did alter the database structure so I could not use it with
2.1. The final solution was to start up the source database on 2.5
server and prepare a clean database on a different machine with 2.1
server. And then I copied the data using FBCopy tool.
To prepare a clean database, you can use something like "isql -x" to
dump the database schema from 2.5, and then run that script on an empty
database with Firebird 2.1.
Good luck.
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
> When I try to restore a backup done in a 2.5 firebird server to a 2.1It is not possible since 2.5 introduces incompatible changes. If you
> firebird server, I get the following error message:
>
> gbak:transportable backup -- data in XDR format
> gbak: ERROR:Expected backup version 1..8. Found 9
> gbak:Exiting before completion due to errors
>
> Isn't it possible to restore a backup database from a 2.5 to a 2.1
> firebird server ?
need to move from 2.5 back to 2.1, the only way would be to copy data
from one database into another. I tried this in the past and met with
another problem: which version to use to access the databases for copy.
IIRC, 2.5 did alter the database structure so I could not use it with
2.1. The final solution was to start up the source database on 2.5
server and prepare a clean database on a different machine with 2.1
server. And then I copied the data using FBCopy tool.
To prepare a clean database, you can use something like "isql -x" to
dump the database schema from 2.5, and then run that script on an empty
database with Firebird 2.1.
Good luck.
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================