Microsoft small business knowledge base

Article ID: 322714 - Last Review: November 2, 2013 - Revision: 2.0

This article was previously published under Q322714
This article has been archived. It is offered "as is" and will no longer be updated.


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

Applies to
  • Microsoft SQL Server 7.0 Standard Edition
kbnosurvey kbarchive kbinfo kbwhitepaper KB322714
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support