Chapter 15. Upsizing Access to SQL Server

In this chapter, 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 chapter looks at various issues and techniques that you can use to develop or enhance your converted application.

After reading this chapter, you will be able to:

  • Effectively plan how to upsize your databases and avoid common pitfalls. ...

Get Microsoft® Access® 2010 VBA Programming Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.