Skip to content

From Access to SQL Server

Spend $50 to get a free DVD!

ISBN-10: 1893115240

ISBN-13: 9781893115248

Edition: 2000

Authors: Russell Sinclair

List price: $49.95
Shipping box This item qualifies for FREE shipping.
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

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…    
Customers also bought

Book details

List price: $49.95
Copyright year: 2000
Publisher: Apress L. P.
Publication date: 8/30/2000
Binding: Paperback
Pages: 340
Size: 7.25" wide x 9.00" long x 0.75" tall
Weight: 1.584
Language: English

Introduction
What Every Access Programmer Needs to Know about SQL Server
Why Migrate?
Planning the Upgrade
The Microsoft Wizard
Data Transformation Services
Using SQL Server 6.5
Using SQL Server 7
Enabling Data Access
Stored Procedures
Getting Connected
Coding with SQL Server Data
Optimizing Access for SQL Server
Selected Tables
Index
Introduction
What Every Access Programmer Needs to Know about SQL Server
SQL Server Architecture
Transact-SQL
Main Database Components
Database Files
Security Modes
System Databases
Database Objects
Using Enterprise Manager (SQL 6.5)
Viewing Data
Using Enterprise Manager (SQL 7.0)
Viewing Data
Finding Information
Why Migrate?
What Is Migrating?
Access versus SQL Server
Size Constraints
Transferring Data
Multi-User Constraints
Maintenance and Administration
Replication
Cost
Reasons to Migrate
Size
Number of Users
Network Traffic
Response Issues
Maintenance and Administration
Replication
Reasons Not to Migrate
Size
Organization of Data
User Connectivity
Cost
Migration Considerations
Planning the Upgrade
Planning How Data Will Be Accessed
Data Access Methods
Analyzing Objects
Tables
Queries
Forms
Reports
Macros
Modules
General Considerations
Documentation
The Microsoft Wizard
Introducing the Upsizing Wizard
Obtaining the Wizard
Preparing to Use the Wizard
Running the Wizard
Evaluating the Wizard
What the Wizard Does and Doesn't Do Well
Recommendations
Data Transformation Services
What Is Data Transformation Services?
DTS Architecture
Relevance to an Access Migration
Accessing DTS
Scripting
Using DTS with the Upsizing Wizard
A Final Word about DTS
Using SQL Server 6.5
Using SQL Server 6.5
Managing Devices
Managing Databases
Managing Logins
Managing Database Objects
Other Tools
A Special Note on Security
Moving On
Using SQL Server 7
Using SQL Server 7
Managing Databases
Managing Logins
Managing Database Objects
Other Tools
A Special Note on Security
Moving On
Enabling Data Access
Tables
Choosing the Appropriate Data Type
Indexing
Timestamps
Views
Creating Views
Why Use Views
An Ounce of Prevention
Stored Procedures
Using Stored Procedures
What Stored Procedures Can Do
Stored Procedure Types
Components
Stored Procedure Syntax
Coding Stored Procedures
Migrating to Stored Procedures
Migrating Queries
Migrating Macros
Migrating Code
Examples
Testing
SQL Power Tools
Getting Connected
Choosing a Connection Method
ODBC
Access Database Projects
Coding with SQL Server Data
Data Coding Choices
Data Access Objects (DAO)
ODBCDirect
ActiveX Data Objects (ADO)
Choosing a Data Access Technology
Using DAO to Manage Local Objects
Working with Data
The Choice Is Yours
Optimizing Access for SQL Server
Reducing Data Transfers
Filtering Data on the Server
Bound Controls
Access Settings
Client-Side Processing
Increasing Throughput
SQL Database Design
Access Database Design
A Plan for the Future
Tip #1: Use Queries to Enhance Security
Tip #2: Perform Bulk Updates Using Stored Queries
Tip #3: Use Parameters Now
Tip #4: Increase Maintainability with Stored Queries
Tip #5: Use ADO for Coding against Data
A Final Word
Selected Tables
SQL Server Data Types
Microsoft Access ODBC Registry Settings
Index