| Subject | Re: Re: RES: [firebird-support] Downgrade from 2.5 to 2.1 |
|---|---|
| Author | Anderson Farias |
| Post date | 2013-12-10T14:07:55Z |
Thanks for the helpful tips Fabiano and Milan
Ragards
Em Domingo, 1 de Dezembro de 2013 12:32, "milanb@..." <milanb@...> escreveu:
---In firebird-support@yahoogroups.com, <peixedragao@...> wrote:
> Hi Sean, thanks for the guidance. That's what I was affraid of. :(
It really isn't a big deal.
1. dump old database schema using "isql -x"
2. create a new database and create objects "isql -i"
3. use fbcopy with "e" switch to copy all the data
FBCopy disables triggers by default, so all your data is the same. It also copies generator values.
http://www.firebirdfaq.org/fbcopy.php
> Hi Sean, thanks for the guidance. That's what I was affraid of. :(
It really isn't a big deal.
1. dump old database schema using "isql -x"
2. create a new database and create objects "isql -i"
3. use fbcopy with "e" switch to copy all the data
FBCopy disables triggers by default, so all your data is the same. It also copies generator values.
http://www.firebirdfaq.org/fbcopy.php
Regards,
Em Quinta-feira, 28 de Novembro de 2013 15:49, "Leyne, Sean" <Sean@...> escreveu:
> As I stated before, I can't just install Classic Server, 'couse the database was
> upgraded to v2.5 (ODS 11.2) and v.2.5 Classic Server cannot be used with glibc
> 2.5. So, I need a way to downgrade the database back to ODS 11.1, so I can
> use Firebird 2.1 Classic.
In that case, you will need to:
- Extract a metadata script for the existing database
- Create a new empty database using v2.1
- Apply the metadata script
- 'Pump' the data between the v2.5 and v2.1 databases
Sean