|
From Access to SQL Server
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.
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.
After reviewing SQL Server, he covers core migration issues, frameworks for decision making, and the migration process itself. Specific topics include 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, and how to convert existing Access reports to stored procedures.
PUBLISHER COMMENTS:
* Sinclair covers the two most common versions of both products, Microsoft Access '97 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
* Introduction
* Chapter 1: What Every Access Programmer Needs to Know about SQL Server
* Chapter 2: Why Migrate?
* Chapter 3: Planning the Upgrade
* Chapter 4: The Microsoft Wizard
* Chapter 5: Data Transformation Services
* Chapter 6: Using SQL Server 6.5
* Chapter 7: Using SQL Server 7
* Chapter 8: Enabling Data Access
* Chapter 9: Storing Procedures
* Chapter 10: Getting Connected
* Chapter 11: Coding with SQL Server Data
* Chapter 12: Optimizing Access for SQL Server
* Appendix A: Selected Tables
* Index
|
