Overview
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
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (12 chapters)
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
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