When an application is migrated from Microsoft Access to Microsoft SQL Server, it is usually done using one of two methods. The first type of migration is a database migration. It involves migrating the backend Access database to SQL Server while maintaining the application interface in Access. The other type of migration involves migrating the interface to another development environment, such as Visual Basic, as well as migrating the backend database to SQL Server. The second type of migration is considerably more complex as it involves two migrations and extensive knowledge in each area. In this book, we will only be looking at the first type of migration, migrating the backend to SQL Server. However, the lessons learned in this type of work can easily be applied to a complete migration of the application and data. The steps involved are very similar, and the planning that is necessary in each type of migration is very important.
KeywordsData Type Network Traffic Unique Index Record Source Integer Data Type
Unable to display preview. Download preview PDF.