With the obvious nonessential objects removed from the database applications, stage three’s goal is to prepare the applications for data consolidation.
Due to the processor-intensive nature, the need for a stable data source, and the level of complexity involved within Step 4, Step 3 is a simple, straight-forward migration of the seven MS Access databases to the client’s chosen database management platform, which is SQL Server.
This is a straight port – table by table – into SQL Server. No columns names nor nonessential data type conversions or additional data entity constraints will be added.
There are many free tools that can aid in this one-to-one database table-by-table migration, but for our needs, the SQL Server Migration Assistant for Access (AccessToSQL) is the tool of choice.
The yellow rectangles below show the database tables after being migrated to a centralized SQL Server database server.