INF: Migrating Your Microsoft Access Database to SQL Server 7.0 (White Paper) (322714)
The information in this article applies to:
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:
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
| Modification Type: | Major | Last Reviewed: | 6/4/2002 |
|---|
| Keywords: | kbinfo kbwhitepaper KB322714 |
|---|
|