From Access to 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 loo...

Full description

Main Author: Sinclair, Russell
Corporate Author: SpringerLink (Online service)
Format: eBook
Language:English
Published: Berkeley, CA Apress 2000, 2000
Subjects:
Online Access:
Collection: Springer Book Archives -2004 - Collection details see MPG.ReNa
Summary: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
Physical Description:XIII, 340 p online resource
ISBN:9781430211310