| |
| |
| 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 | |