PDA

View Full Version : DF -> PSQL conversion: First reindex?



Pieter van Dieren
8-Jul-2005, 10:00 AM
Suppose a dataflex file has a bad index and a conversion from Dataflex to
Pervasive needs to take place.
Is it necessary to reindex before the conversion?

--

Pieter

Anders Öhrt
8-Jul-2005, 01:34 PM
> Suppose a dataflex file has a bad index and a conversion from Dataflex to
> Pervasive needs to take place.
> Is it necessary to reindex before the conversion?

No, since the indices are created from scratch by PSQL they will be correct.

// Anders

Igor van Houttum
11-Jul-2005, 05:00 AM
Pieter,

A bad index might indicate bad data. Which would cause the conversion to
fail while copying the bad records, so you might as well first clean up the
data.


Regards,
Igor van Houttum
Data Access Europe, BV

"Pieter van Dieren" <pieter.v.dieren@synerga.nl> wrote in message
news:6VSis48gFHA.788@dacmail.dataaccess.com...
>
> Suppose a dataflex file has a bad index and a conversion from Dataflex to
> Pervasive needs to take place.
> Is it necessary to reindex before the conversion?
>
> --
>
> Pieter
>

Nicholas Herlick
4-Aug-2005, 08:59 PM
Pieter,

That's what I've always done on general principle. One time I didn't and
sure enough a db's indexes were damaged and that db would not convert. No
harm done other than time wasted. After reindex it converted fine.

Nick


"Pieter van Dieren" <pieter.v.dieren@synerga.nl> wrote in message
news:6VSis48gFHA.788@dacmail.dataaccess.com...
>
> Suppose a dataflex file has a bad index and a conversion from Dataflex to
> Pervasive needs to take place.
> Is it necessary to reindex before the conversion?
>
> --
>
> Pieter
>
>