Subject RE: [firebird-support] Fb 1.5.4 - RDB$RELATION_FIELDS not in RDB$RELATIONS
Author Alan McDonald
> Alan McDonald wrote:
> >> --
> >> Aage J.
> >> Not looking forward to creating a new db and pumping data (late
> >> evening or weekend work).
> >>
> >
> > this task isn't onerous with clever components datapump, you
> just set it up
> > and let it run.
>
> The "Interbase Datapump 3.4" is dated November 2002. Will it work
> (flawlessly) with Fb/1.5.4 ?

I've used it with FB2 without any errors.

>
> SET made (years ago) a nice utility for moving data, but it requires
> metadata to be in place. Delphi+IBO - quite quick.
>
> The time consuming part is building indexes - close to a couple of
> hours is my estimate.

you can turn indexes off while you pump
I have a script to re-activate/rebuild all indexes
Alan

>
>
> --
> Aage J.
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>