Microsoft KB Archive/322714

= INF: Migrating Your Microsoft Access Database to SQL Server 7.0 (White Paper) =

Article ID: 322714

Article Last Modified on 6/4/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q322714



SUMMARY
As the need for an enterprise-scale, high-performance database increases, organizations sometimes move from the file-server environment of the Microsoft Access Jet engine to the client/server environment of SQL Server. The tools and wizards in SQL Server 7.0, such as Enterprise Manager, Data Transformation Services (DTS), Query Analyzer, and SQL Profiler, make it easy to migrate Access data and applications to SQL Server. The document that this article references describes how to migrate Access tables and queries to SQL Server scripts, views, and stored procedures, and it outlines methods to make sure that applications, after they are in place, are tuned to run efficiently.

To view this white paper, visit the following Microsoft Web site:

Migrating Your Microsoft Access Database to SQL Server 7.0

Included in this document:
 * SQL Server Tools Used in Migrations
 * Moving Tables and Data
 * Migrating Microsoft Access Queries
 * Additional Design Considerations
 * Connecting Your Applications
 * Finding More Information

Additional query words: access whitepaper

Keywords: kbinfo kbwhitepaper KB322714

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.