convert_1_2 - Taking too long on a larger db?

[Ruslan Zasukhin]

On 26/5/07 2:01 AM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

Hi Barry,

> OK, I'm now able to follow this up a bit better.
> 
> Please have a look at what I believe to be a better converter on:
> 
> http://www.BarrySumpter.com
> 
> The convert_1_2_bgs.rb has a better error trapping routine than the original
> project
> And, I believe, better than Valentina Studio.

Ok good.
 
> The error I'm getting is:
> 
> Error: 144643 - Attempt to insert duplicate key row in object "Suppliers"
> with unique index "U_Suppliers_bigname".

This means that
    * you have some field marked as UNIQUE
    * v1 database contains 2 records with the same value for this field
    * v2 refuse record with SECOND value.

> So far, I've just trapped this error
> but have NOT had time to chase down the Valentina documentation for it.
> 
> I'll return later to chase it down further.
> 
> hth
> 
> And positive constructive suggestions would be greatly appreciated.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]