Subject RE: [firebird-support] Migrating from Access to Firebird (Where are the autoincrement fields?)
Author Thomas Steinmaurer
> I´m thinking about migrate my old database (in the MS Access format) to the Firebird format. But, reading here and
> there, trying to make this migration a small doubt come to my mind: where are the autoincrement fields in Firebird? Does
> Firebird have anything like these autoincremental fields that exists in databases such as Access and Paradox? If does,
> how can I declare a field to be of this type and, most important, when migrating my old database (MS Access) to
> firebird, will I loose these fields or they will be translated using the type Integer or something like it?

Additional to Catalin's answer, you could make your
migration life easier by using a migration utility
like this one.
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=sql2gdb

Or IBDataPump. Search with Google for a link.


Best Regards,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase/Firebird
http://www.iblogmanager.com