Subject Re: FB 1.5 -> FB 2.0
Author bertchughes
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

Great, thanks for your help. So I just need to take my FB1.5 backups,
created with gbak 1.5 or 2.0, restore using gbak 2.0.

Bert

>
> Bert Hughes wrote:
> > Is there is simple way to migrate a FB 1.5 to FB 2.0 database? The
release
> > notes & quick start guide offer no hints on how to do this, but
reading the
> > chapter on "Dealing with New Security Database" gives idea that
you can take
> > a backup of original DB, restore using FB 2 gbak to convert to new
structure
> > ???
> >
>
> FB 2.0 could read 1.5 databases, but not all new features will be
> available, some new features depends on new ODS structure FB 1.5 uses
> ODS 10.1 and FB 2.0 uses ODS 11 that has new capabilities.
>
> The procedure you are talking about on the release notes is to convert
> the security.fdb to security2.fdb and don't lost all the created users.
>
> To take all the FB 2.0 potential, do a back-up/restore cycle.
>
> > Or must you start w/ all new databases created from DDL scripts,
populate
> > via your favorite tools?
> >
>
> This is not necessary... This is almost what gbak will do on the
restore
> process... create a new database, create all metadata, populate the
> tables with the data.
>
> > Bert
> >
> >
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>