From Access to SQL Server / Edition 1

From Access to SQL Server / Edition 1

by Russell Sinclair
     
 

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

See more details below

Overview

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

Product Details

ISBN-13:
9781893115248
Publisher:
Apress
Publication date:
08/31/2000
Edition description:
BK&CD-ROM
Pages:
340
Product dimensions:
7.50(w) x 9.25(h) x 9.25(d)

Related Subjects

Table of Contents

Introduction.- What is SQL Server?- Why Upgrade?- Planning the Upgrade.- The Microsoft Wizard.- Using Data Transformation Services.- Using SQL Server.- Tables and Views.- Stored Procedures.- Connecting the Access front end to SQL Server.- Working with Data from SQL Server.- Optimizing the Access front-end.- Access design considerations.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >