Subject Re: [ib-support] DBISAM to FB
Author Daniel Rail
Hi,

> Is anyone aware of any docs relating to this subject... or advice on how to
> proceed?

> Issues I've come across so far:
> - Reserved Words... oh boy<g>

There's a possibility of this happening with any conversion.

> - Boolean, Time and AutoInc field types not supported

FB 1.5 will have support for Boolean fields. If you use dialect 3,
Time fields are already supported. AutoInc fields can be setup as an
Integer field that is a primary key and using generators to keep track
of the latest value used.

> - Same Index names, even on different tables, not allowed

Correct. If you look at some of the DML statements (i.e. ALTER
INDEX), you'll notice that only the index name is needed and the table
name is not used in it.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)