Amon Consulting

PO Box 952, Nelson, New Zealand

www.amon.co.nz   info@amon.co.nz

• ExportR
  Revelation application migration and redevelopment data export software
• Revelation Data Migration
  Partial or full Revelation application prototyping, redevelopment and data migration
• OpenInsight
  OpenInsight Data Export Service
• MS Access
  Conversion of exported data to a MS Access database
• For more information, please email exportr@amon.co.nz

If required, we can automatically generate an MS Access database using the metadata information in the formats file generated by the ExportR run

• The formats file contains data dictionary detail for all exported tables plus maximum field length information and field value counts
• No application data is required to generate the database so there are no data confidentiality issues
• The MS Access database is created with appropriately named tables and fields, based on the Revelation names, using mixed case and with underscores and full stops removed
• Suitable datatypes are allocated to each field and field sizes are based on the dictionary field size or the maximum field size found

Example

Text fields greater than 256 are allocated the memo datatype and those less than 256 are allocated a text datatype with a field size equal to the dictionary field size or the maximum field size, whichever has the greater value

We also provide a program to load and reload the exported data to the MS Access database

The load software can be applied regardless of subsequent changes to MS Access table names, table structures, field names or datatypes

Fields that fail validation during the data load are logged