Home / MS-Access / Getting Started

Upsizing Access to SQL Server

In this tutorial, you start by looking at the need for planning before you convert an existing Microsoft Access 2010 back-end database to Microsoft SQL Server. You will then look at two popular Microsoft tools for upsizing a database; the Upsizing Wizard (part of Access) and SQL Server Migration Assistant, which you can download free of charge. The final part of the tutorial looks at various issues and techniques that you can use to develop or enhance your converted application.

After reading this tutorial, you will be able to:

  • Effectively plan how to upsize your databases and avoid common pitfalls.
  • Understand how to use the Upsizing Wizard or SSMA to convert an application.
  • Understand design techniques that can be used to further develop your application after it is upsized.