Advertisement

Planning the Upgrade

  • Russell Sinclair

Abstract

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.

Keywords

Data Type Network Traffic Unique Index Record Source Integer Data Type 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Russell Sinclair 2000

Authors and Affiliations

  • Russell Sinclair

There are no affiliations available

Personalised recommendations