Pre-analysis for the migration of two MS Access databases to MS SQL Server
Project duration: 2 months
Brief description
Based on the results of the "Pilot Migration from Access to SQL Server (3346)" project, the migration from MS Access 2013 to MS SQL Server 2012 is analyzed using two customer databases for feasibility and expected technical difficulties during implementation.
Supplement
The initial documents are the checklist and the migration report from the preceding project. The check determines which steps are required for preparation and post-processing of the migration (urgent) and which technical difficulties can generally be determined from the migration database structure. The database are migrated using the "SQL Server Migration Wizard".
Subject description
The result is a revised checklist that describes the steps required for the migration, especially those needed for preparation and post-processing in MS Access. In addition, all migration steps are described in detail in a migration report. In a management summary, the entire procedure is summarized in a short format. The results gained in this way help the department more precisely estimate the business workload of converting the databases. According to customer specifications, the implementation must not affect users too severely.