ValentineĀ“s Day Promo Springer Apress

From Access to SQL Server

By Russell Sinclair

  • eBook Price: $34.99
  • Print Book Price: $49.95
Buy eBook Buy Print Book

From Access to SQL Server Cover Image

This comprehensive guide delves into the often intimidating process of migrating Access databases to SQL Server.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-893115-24-8
  • 340 Pages
  • User Level: Beginner to Advanced
  • Publication Date: August 30, 2000
  • Available eBook Formats: PDF

Related Titles

  • Pro Power BI Desktop
  • User Group Leadership
  • SQL Server AlwaysOn Revealed
  • Next Generation Databases
  • Expert Performance Indexing in SQL Server
  • Expert SQL Server in-Memory OLTP
Full Description

Although Microsoft's Access Database is extremely popular and adequate for smaller scale applications, many Access developers are discovering that their applications need a more robust, enterprise-ready database system like SQL Server. This book is designed as a guide for Access programmers looking to make this transition, but who have little or no prior experience with SQL Server.

Veteran author Russell Sinclair begins by discussing SQL Server, its architecture and application environment, and its differences from Access. He provides coverage of key topics including security, data storage, system databases, database objects, and queries.

  • Illustrates best practices for migrating Access databases to SQL Server
  • Carefully explains the differences between these two systems and the changes needed for a smooth migration
  • Assumes no prior knowledge of SQL Server

What you’ll learn

  • Core migration issues
  • Frameworks for decision making
  • The migration process itself
  • Microsoft's Upsizing Wizards
  • Use of SQL Server's Data Transformation Services (DTS)
  • Options for connecting Access databases directly to SQL Server
  • Differences and similarities between Tables and Views in Access and SQL Server
  • How to write SQL Server stored procedures
  • How to convert existing Access reports to stored procedures

Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published


    1. Pro SQL Server Wait Statistics


      View Book

    2. SQL Server T-SQL Recipes


      View Book

    3. Entity Framework 6 Recipes


      View Book

    4. Healthy SQL


      View Book