HAPPY HOLIDAYS: Get a special discount on Apress Access! Subscribe today >>

From Access to SQL Server

Authors: Sinclair, Russell

Download source code

Buy this book

eBook $34.99
price for USA
  • ISBN 978-1-4302-1131-0
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $49.95
price for USA
  • ISBN 978-1-893115-24-8
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
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 authors

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.

Table of contents (12 chapters)

Buy this book

eBook $34.99
price for USA
  • ISBN 978-1-4302-1131-0
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $49.95
price for USA
  • ISBN 978-1-893115-24-8
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
From Access to SQL Server
Authors
Copyright
2000
Publisher
Apress
Copyright Holder
Russell Sinclair
eBook ISBN
978-1-4302-1131-0
DOI
10.1007/978-1-4302-1131-0
Softcover ISBN
978-1-893115-24-8
Edition Number
1
Number of Pages
XIII, 340
Topics