▼
MSDN Library - April 2000
▶
Welcome to the MSDN Library
▶
Visual Studio 6.0 Documentation
▶
Office Developer Documentation
▶
Windows CE Documentation
▶
Platform SDK
▶
SDK Documentation
▶
DDK Documentation
▼
Windows Resource Kits
About Windows Resource Kits
▼
BackOffice Resource Kit
BackOffice Resource Kit, Second Edition
▶
Microsoft Exchange Server Resource Guide
▶
Microsoft Systems Management Server 2.0 Resource Guide
▶
Microsoft SNA Server Resource Guide
▼
Microsoft SQL Server 7.0 Resource Guide
▶
Part 1: Introduction
▶
Part 2: Planning
▶
Part 3: Deployment
▶
Part 4: Performance Tuning
▶
Part 5: Integration
▶
Part 6: Tools and Utilities
▶
Part 7: Troubleshooting
▶
Part 8: Disaster Recovery
▶
Part 9: Architecture
▶
Part 10: Security
▼
Part 11: Upgrading and Migrating
▶
Chapter 17: Upgrading to SQL
▼
Chapter 18: Migrating Oracle Databases to Microsoft SQL
Target Audience
Development and Application Platforms
▶
Overview
▶
Architecture and Terminology
Installing and Configuring Microsoft SQL Server
▶
Defining Database Objects
▶
Enforcing Data Integrity and Business Rules
▶
Transactions, Locking, and Concurrency
▶
SQL Language Support
▶
Implementing Cursors
▶
Tuning SQL Statements
▼
Using ODBC
Recommended Conversion Strategy
ODBC Architecture
Forward-only Cursors
Server Cursors
Scrollable Cursors
Multiple Active Statements (hstmt) per Connection
Data Type Mappings
ODBC Extended SQL
Outer Joins
Date, Time, and Timestamp Values
Calling Stored Procedures
Native SQL Translation
The Common.cpp Sample Program
Manual Commit Mode
▶
Developing and Administering Database Replication
▶
Migrating Your Data and Applications
▶
Database Examples
▶
SQL Server Tools Used in Migrations
Moving Tables and Data
▶
Migrating Microsoft Access Queries
▶
Additional Design Considerations
Connecting Your Applications
SQL Server and Access Query Syntax
Understanding the Migration Process
▶
Reviewing Architectural Differences
Migrating Tables and Data
▶
Reviewing Sybase T-SQL and Microsoft Transact-SQL Differences
Understanding Database Administration Differences
Migration Checklist
System Databases and Data
▶
Chapter 21: Migrating Btrieve Applications to Microsoft SQL
▶
Part 12: Programming
▶
Microsoft Site Server 3.0 Commerce Edition Resource Kit
▶
Windows 95 Resource Kit
▶
Windows 98 Resource Kit
▶
Windows CE PC Companion Resource Kit
▶
Windows NT 3.51 Resource Kit
▶
Windows NT Server 4.0 Resource Kit
▶
Windows NT Workstation 4.0 Resource Kit
▶
Windows 2000 Server Resource Kit
▶
Knowledge Base
▶
Technical Articles
▶
Backgrounders
▶
Specifications
▶
Books
▶
Partial Books
▶
Periodicals
▶
Samples