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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
