07 / Database migration
Database migration while retaining existing applications
Successful database migration requires more than copying tables. Database logic, data integrity and application behavior need careful review.
Typical challenges
- Replacing an existing database platform
- Preserving business application behavior
- Adapting SQL routines and data types
- Validating migrated data
Services
- Analyze database objects and dependencies
- Transfer and adapt database logic
- Migrate data, including complex formats
- Validate results and troubleshoot
Technologies and practical experience
- Informix-to-PostgreSQL migration involving large data volumes and BLOBs.
- Validation using record counts, data volumes and sample content checks.
- ODBC connection changes, application testing and troubleshooting in an ongoing higher-education project.
- Access-to-SQL Server migration at LDBV: migrated the backend while retaining and optimizing the existing Access frontend.
Ongoing: Informix to PostgreSQL
I am contributing to a backend database migration in higher education. Existing business applications remain in use. The migration is ongoing.