Migrating Your Microsoft Access Database to.docVIP

Migrating Your Microsoft Access Database toMicrosoft SQL?Server 7.0 The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. This document is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS DOCUMENT. ?1998 Microsoft Corporation. All rights reserved. Microsoft, ActiveX, Visual Basic, Windows, and Windows?NT are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other trademarks and tradenames mentioned herein are the property of their respective owners. The names of companies, products, people, characters, and/or data mentioned herein are fictitious and are in no way intended to represent any real individual, company, product, or event, unless otherwise noted. Part number: 098-82594 将你的Microsoft Access数据库移植到Microsoft SQL Server 7.0 当一个机构成长和演变时，对数据库系统的要求也变化。当企业级伸缩性和高性能数据库的需求增加时，一些机构有时会从Microsoft Access喷射引擎的文件服务器环境转入Microsoft SQL Server的客户机/服务器环境。SQL Server 7.0的工具和向导，如Enterprise Manager、Data Transformation Services（数据转换服务）、Query Analyzer（查询分析器）和 Server Profiler，使从Access数据和应用程序到SQL Server的移植轻松简便。本文描述了怎样将表和查询移植到SQL Server的脚本、视图和存储过程，概述了几种方法，确保以前正常的应用程序转变后有效运行。 本文包括： 移植使用的SQL Server 工具 移动表和数据 移植Microsoft Access查询 其它设计时需要考虑的事项 连接你的应用程序 附录A：Microsoft SQL Server与Microsoft Access查询语法不同点 附录B：优化客户机/服务器性能的基础知识文章 更多信息 Contents Contents 3 Introduction 4 SQL?Server Tools Used in Migrations 5 SQL?Server Enterprise Manager 5 Data Transformation Services (DTS) 5 SQL?Server Query Analyzer 6 SQL?Server Profiler 6 Moving Tables and Data 7 Migrating Microsoft Access Queries 8 Migrating Microsoft Access Queries into Stored Procedures and Vi