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.

In this tutorial:

  1. Planning for Upsizing
  2. Boolean Data
  3. IMAGE, VARBINARY(Max), and OLE Data
  4. Cycles and Multiple Cascade Paths
  5. Replicated Databases and Random Autonumbers
  6. Unique Index and Ignore Nulls
  7. Timestamps and Row Versioning
  8. Schemas and Synonyms
  9. Upsizing Wizard and the SQL Server Migration Assistant
  10. Upsizing to Use an Access Data Project
  11. SSMA
  12. Comparing Table Conversion in the Upsizing Wizard and SSMA
  13. Comparing Query Conversion in the Upsizing Wizard and SSMA
  14. Developing with Access and SQL Server
  15. Stored Procedures and Temporary Tables
  16. Handling Complex Queries
  17. Performance and Execution Plans
  18. SQL Server Profiler