OK, this is the diagnostic:

1. the wizard does not recognize type as a reserved keyword (it should
recognize it and mangle it to typeCol).
2. the wizard outputs the NUMERIC field improperly - I think it's inverting
the order of precision/scale (except for currency data types, which are
hardcoded to NUMERIC(18,4) to comply with OLE DB's specs)

After these errors, the others are a 'cascade' - the tables don't get
created, so data can't be pumped and keys can't be set.

Marcelo Lopez Ruiz

----- Original Message -----
From: Andreas Tille <tillea@...>
To: <IB-Conversions@egroups.com>
Sent: Wednesday, August 30, 2000 5:56 AM
Subject: [IB-Conversions] RE: Re: MS SQL 2 InterBase Wizard


>
> On Wed, 30 Aug 2000, Claudio Valderrama C. wrote:
>
> > If Marcelo is using the list's archives, you need to go to egroups.com
and
> > sign in with your email address, then you'll be able to see the list of
> > emailing lists you are subscribed. Each emailing list in egroups has a
FILES
> > section.
> Thanks, it was my stupidity not to look there, but as I stated in my
> previous mail I found it and tested it. Here are more testing results:
>
> I append the resulting scripts and the error messages they produced.
> May be this will help a little bit in debugging. Please tell me if
> you need any further informations. It was a test database for a TDS
> driver which makes heavy use of different (may be all) types.
>
> Unfortunately I have not time to compare the results of the migration.
> Does anybody have a good idea how to compare each single entry of
> both the source and the target database?
>
> Kind regards
>
> Andreas.
>
> To unsubscribe from this group, send an email to:
> IB-Conversions-unsubscribe@egroups.com
>
>
>