This thesis is concerned with the migration of Microsoft Access databases to Mendix Platform. We investigate similarities and dierences between the data models of the two systems, discuss issues in regards to data migration and also examine possible options for migrating database queries. A tool was implemented for the automated migration of an MS Access schema to Mendix Domain Model and we present its possibilities and limitations. Additionally, since many real-world databases lack an explicit definition of foreign key relationships, we implemented a tool for discovering those constraints. Our approach was to examine the data for inclusion dependencies, and our results show that these constraints are successfully retrieved. However, a big number of false positives is also discovered in databases that make extended use of Autonumber fields.
Additional Metadata
Keywords data migration, schema migration
THEME Software (theme 1)
Thesis Advisor T. van der Storm (Tijs)
Citation
Boudale, T. (2014, January). Migration of MS Access Databases to Mendix Platform .