From Access to SQL Server / Edition 1

From Access to SQL Server / Edition 1

by Russell Sinclair
     
 

ISBN-10: 1893115240

ISBN-13: 9781893115248

Pub. Date: 08/31/2000

Publisher: Apress

- Teaches how to avoid hidden problems and "gotchas" associated with migration from Access to SQL Server
- Learn the differences between these two systems and how Microsoft Access interfaces with SQL Server
- Covers Microsoft Access 97 and 2000 and Microsoft SQL Server 6.5 and 7
Microsoft Access has become the most popular desktop database program for

Overview

- Teaches how to avoid hidden problems and "gotchas" associated with migration from Access to SQL Server
- Learn the differences between these two systems and how Microsoft Access interfaces with SQL Server
- Covers Microsoft Access 97 and 2000 and Microsoft SQL Server 6.5 and 7
Microsoft Access has become the most popular desktop database program for software development. However, many programmers have encountered limitations with the program and are choosing to migrate their databases to SQL Server. This process is fraught with hidden problems that many developers do not expect. In this book Sinclair teaches Access developers what they need to know about SQL Server. He includes detailed information on how to work with SQL Server outside of the Access environment and how to design efficient SQL Server databases. The author also discusses the planning that should go into a database migration and decisions that need to be made along the way.

Author Biography: Russell Sinclair is a Senior Programmer with Questica, Inc., a company specializing in software for the customized machinery manufacturing industry. Sinclair is a frequent contributor to Smart Access, and has extensive experience in Access and SQL Server development.

Product Details

ISBN-13:
9781893115248
Publisher:
Apress
Publication date:
08/31/2000
Edition description:
2000
Pages:
340
Product dimensions:
7.52(w) x 9.25(h) x 0.36(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 >