WIN $150 GIFT VOUCHERS: ALADDIN'S GOLD

Close Notification

Your cart does not contain any items

From Access to SQL Server

Russell Sinclair

$99.95   $85.37

Paperback

Not in-store but you can order this
How long will it take?

QTY:

English
APress
31 August 2000
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.
By:  
Imprint:   APress
Country of Publication:   United States
Edition:   Softcover reprint of the original 1st ed.
Dimensions:   Height: 235mm,  Width: 191mm,  Spine: 18mm
Weight:   664g
ISBN:   9781893115248
ISBN 10:   1893115240
Pages:   340
Publication Date:  
Audience:   General/trade ,  ELT Advanced
Format:   Paperback
Publisher's Status:   Active
* 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

Russell Sinclair is an MSCD and the owner of Synthesystems, a technology consulting firm specializing in Visual Basic, SQL Server, and Microsoft Access development. Russell is the senior systems architect with Questica, Inc., a company specializing in software for custom-design manufacturers, and a contributing editor for Smart Access. In addition, he has extensive experience in Access and SQL Server development.

See Also