Skip to main content
SpringerLink
Log in
Apress
Book cover

From Access to SQL Server

  • Book
  • © 2000

Overview

Authors:
  1. Russell Sinclair
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Sinclair covers the two most common versions of both products, Microsoft Access 7 and 2000 and Microsoft SQL Server 6.5 and 7

  • The author offers his own tips and techniques based on practical hands-on experience. The resulting book teaches developers how to accomplish their goal without over-simplifying the migration process

  • Most books do not cover the reasons behind the database migration process. This book helps developers make educated decisions about how to implement their changes

  • Includes supplementary material: sn.pub/extras

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (12 chapters)

  1. Front Matter

    Pages i-xiii
    Download chapter PDF

  2. What Every Access Programmer Needs to Know about SQL Server

    • Russell Sinclair
    Pages 1-23

  3. Why Migrate?

    • Russell Sinclair
    Pages 25-35

  4. Planning the Upgrade

    • Russell Sinclair
    Pages 37-57

  5. The Microsoft Wizard

    • Russell Sinclair
    Pages 59-97

  6. Data Transformation Services

    • Russell Sinclair
    Pages 99-139

  7. Using SQL Server 6.5

    • Russell Sinclair
    Pages 141-173

  8. Using SQL Server 7

    • Russell Sinclair
    Pages 175-206

  9. Enabling Data Access

    • Russell Sinclair
    Pages 207-219

  10. Stored Procedures

    • Russell Sinclair
    Pages 221-248

  11. Getting Connected

    • Russell Sinclair
    Pages 249-279

  12. Coding with SQL Server Data

    • Russell Sinclair
    Pages 281-305

  13. Optimizing Access for SQL Server

    • Russell Sinclair
    Pages 307-319

  14. Back Matter

    Pages 321-340
    Download chapter PDF
Back to top

Keywords

About this book

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

About the author

Russell Sinclair is an MSCD and the owner of Synthesystems, a technology consulting firm specializing in Visual Basic, SQL Server, and Microsoft Access development. Russell is the senior systems architect with Questica, Inc., a company specializing in software for custom-design manufacturers, and a contributing editor for Smart Access. In addition, he has extensive experience in Access and SQL Server development.

Bibliographic Information

  • Book Title: From Access to SQL Server

  • Authors: Russell Sinclair

  • DOI: https://doi.org/10.1007/978-1-4302-1131-0

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Springer Book Archive

  • Copyright Information: Russell Sinclair 2000

  • Softcover ISBN: 978-1-893115-24-8Published: 31 August 2000

  • eBook ISBN: 978-1-4302-1131-0Published: 01 September 2000

  • Edition Number: 1

  • Number of Pages: XIII, 340

  • Topics: Database Management, Software Engineering/Programming and Operating Systems

Publish with us

Policies and ethics

Back to top

Search

Navigation