SQL Server Migration AssistantSQL Server Migration Assistant

Microsoft SQL Server 迁移助手 (SSMA) 是一项工具,旨在将数据库从 Microsoft Access、DB2、MySQL、Oracle 和 SAP ASE 自动迁移到 SQL Server。Microsoft SQL Server Migration Assistant (SSMA) is a tool designed to automate database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and SAP ASE.

迁移源Migration Sources

支持的源和目标版本Supported Sources and Target Versions

对于支持的源,请查看 SSMA 下载的下载中心上的信息。For supported sources, review the information on the Download Center for the SSMA download.

SSMA 支持以下目标版本。The following target versions are supported for SSMA.

  • SQL Server 2012SQL Server 2012
  • SQL Server 2014SQL Server 2014
  • SQL Server 2016SQL Server 2016
  • Windows 和 Linux 上的 SQL Server 2017SQL Server 2017 on Windows and Linux
  • Windows 和 Linux 上的 SQL Server 2019SQL Server 2019 on Windows and Linux
  • Azure SQL DatabaseAzure SQL Database
  • Azure SQL 托管实例Azure SQL Managed Instance
  • Azure Synapse Analytics * *Azure Synapse Analytics**

* * 只有 SSMA for Oracle 支持此目标。** This target is supported only by SSMA for Oracle.

下载Downloads

获取 SSMA 支持Getting SSMA Support

) Microsoft SQL Server 迁移助手 (的帮助和支持:Help and support for Microsoft SQL Server Migration Assistant (SSMA):

  • 产品帮助 -若要访问产品支持,请启动 SSMA,并选择 "帮助" 菜单或按 F1 键。Product help - To access product support, launch SSMA, and select the Help menu or press the F1 key.

  • SQL Server 社区论坛 -提出 SQL Server 社区中的问题SQL Server community forums - Ask a question in the SQL Server Community

    • SQL Server 社区 -由 SQL Server 社区监视的新闻组和论坛。SQL Server Community - Newsgroups and forums that are monitored by the SQL Server community. 此站点还列出了诸如博客和网站之类的社区信息源。This site also lists community information sources, such as blogs and Web sites.

    • SQL Server Developer 中心社区 -对 SQL Server 开发人员有用的新闻组、论坛和其他社区资源SQL Server Developer Center Community - Newsgroups, forums, and other community resources that are useful to SQL Server developers

  • 辅助支持 -请参阅 https://support.microsoft.com/assistedsupportproducts 并搜索 "SQL Server 迁移助手"。Assisted support - Go to https://support.microsoft.com/assistedsupportproducts and search for 'SQL Server Migration Assistant'. 选择你的版本,然后选择 "启动请求"。Select your version, then select "start request." SQL Server 迁移助手工具附带了辅助支持。Assisted support is included with the SQL Server Migration Assistant Tool.

  • 顶级支持 -如果你拥有顶级合同,则可以在 premier Online 门户上获得顶级支持。Premier support - If you have a Premier Contract, you can get Premier support on the Premier Online portal.

  • 咨询服务 -对于合作伙伴辅助迁移,请参阅 Azure 数据库迁移指南Consulting services - For partner assisted migrations, go the Azure Database Migration Guide.

本文档(包括本文档中使用的示例应用程序)仅供参考,并在无任何明示或暗示担保的情况下提供。This documentation, including sample applications herein, is provided for information purposes only, and this documentation is provided without any warranties, either express or implied. 本文档中的信息(包括 URL 和其他 Internet 网站引用)如有更改,恕不另行通知。Information in this documentation, including URL and other Internet Web site references, is subject to change without notice. 由于使用本文档而带来的任何风险或后果均由用户自行承担。The entire risk of the use or the results of the use of this documentation remains with the user.

本文档中包含的示例主要用于说明概念以及特定语句或子句的合理用法。The primary purpose of a sample contained within this documentation is to illustrate a concept, or a reasonable use of a particular statement or clause. 大多数示例不包括完整的生产系统中通常会找到的所有代码,因为某些常用的数据验证和错误处理会被删除,以使示例集中于特定的概念或语句上。Most samples don't include all of the code that may normally be found in a full production system, as some of the usual data validation and error handling is removed to focus the sample on a particular concept or statement. 对于这些示例或任何包括的源代码,技术支持不可用。Technical support isn't available for these samples or for any included source code.

除非另有说明,本文档示例所提及的公司、组织、产品、域名、电子邮件地址、人物、地点和事件纯属虚构。不应据此联想或推断到任何真实的公司、组织、产品、域名、电子邮件地址、人物、地点或事件。Unless otherwise noted, the example companies, organizations, products, domain names, e-mail addresses, people, places, and events depicted herein are fictitious, and no association with any real company, organization, product, domain name, e-mail address, person, place, or event is intended or should be inferred. 用户有责任遵守所有适用的版权法/著作权法。Complying with all applicable copyright laws is the responsibility of the user. 除了版权法/著作权法所规定的权利以外,未经 Microsoft Corporation 的明确书面许可,不得对本文档中的任何部分进行复制、存储或引入检索系统,也不能以任何形式或借助任何手段(电子、机械、影印、录制或其他手段)、出于任何目的进行传播。Without limiting the rights under copyright, no part of this documentation may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft 可能拥有本文档中内容的专利、专利申请、商标、版权或其他知识产权。Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this documentation. 除非 Microsoft 提供了明确的书面许可协议,否则提供本文档并不意味着赋予您有关这些专利、商标、版权或其他知识产权的任何许可。Except as expressly provided in any written license agreement from Microsoft, the furnishing of this documentation does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

© 2019 Microsoft Corporation.© 2019 Microsoft Corporation. 保留所有权利。All rights reserved.

Microsoft、Windows、Windows NT、Windows Server、Active Directory、ActiveX、BackOffice、bCentral、BizTalk、DirectX、Excel、Hotmail、IntelliSense、J/Direct、Jscript、Microsoft Press、MSDN、MS-DOS、Outlook、PivotChart、PivotTable、PowerPoint、SharePoint、SQL Server、Visual Basic、Visual C#、Visual C++、Visual FoxPro、Visual InterDev、Visual J#、Visual J++、Visual SourceSafe、Visual Studio、Win32、Win32s、Windows Mobile、Windows Server System 和 WinFX 是 Microsoft Corporation 在美国和/或其他国家/地区的注册商标或商标。Microsoft, Windows, Windows NT, Windows Server, Active Directory, ActiveX, BackOffice, bCentral, BizTalk, DirectX, Excel, Hotmail, IntelliSense, J/Direct, Jscript, Microsoft Press, MSDN, MS-DOS, Outlook, PivotChart, PivotTable, PowerPoint, SharePoint, SQL Server, Visual Basic, Visual C#, Visual C++, Visual FoxPro, Visual InterDev, Visual J#, Visual J++, Visual SourceSafe, Visual Studio, Win32, Win32s, Windows Mobile, Windows Server System, and WinFX are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries/regions.

SAP NetWeaver 是 SAP AG 在德国和其他几个国家/地区的注册商标。SAP NetWeaver is the registered trademark of SAP AG in Germany and in several other countries/regions.

所有其他商标均为其各自所有者的财产。All other trademarks are property of their respective owners.

SQL Server 支持和升级文档策略Documentation Policy for SQL Server Support and Upgrade

SQL Server 文档中显示的内容仅在经过充分测试后才发布。Content that appears in SQL Server documentation is published only after it has been tested sufficiently. 产品文档-SQL Server 联机丛书、自述文件、已知问题文档和知识库文章-包含有关 SQL Server 功能和功能的内容,这些内容和功能足以确保所有客户正常使用。Product documentation - SQL Server Books Online, readme files, known issues documents, and Knowledge Base articles - contains content regarding SQL Server features and functionality that is robust enough to be safe for general use by all customers. 本策略适用于所有 SQL Server 文档,包括版本和 Service Pack 的自述文件;自述文件被视为联机丛书的扩展。This policy applies to all SQL Server documentation, including readme files for releases and services packs; a readme file is considered an extension of Books Online.

在某些情况下,特定功能不是客户应直接使用的功能,因此,未将其记录其中。In some cases, a particular feature is not something that customers should use directly and, therefore, it is not documented. 除非某种功能还在 Microsoft 发布的 SQL Server 文档中进行讨论,否则来自第三方书籍或网站的内容不受 Microsoft 客户支持的支持,并不应在生产数据库或应用程序中使用。Unless a feature is also discussed in SQL Server documentation published by Microsoft, content from third-party books or Web sites is not supported by Microsoft customer support, and should not be used in production databases or applications.

客户不得使用未记录的 API,其中包括但不限于:存储过程、扩展存储过程、函数、视图、表、列、属性或元数据。Customers must not use undocumented APIs, including but not limited to: stored procedures, extended stored procedures, functions, views, tables, columns, properties, or metadata. Microsoft 客户支持不支持利用或使用未记录的入口点的数据库或应用程序。Microsoft customer support does not support databases or applications that leverage or use undocumented entry points.

对于利用和使用未记录的入口点的应用程序和数据库,升级至 SQL Server 的未来版本的服务器和数据库未得到保证。Server and database upgrades to future versions of SQL Server are not guaranteed for applications and databases that leverage and use undocumented entry points. 必须将 SQL Server 特性和功能的使用限制为 Microsoft SQL Server 文档中包含的内容。Use of SQL Server features and functionality must be limited to those that are included in Microsoft SQL Server documentation. 如果功能未在 Microsoft SQL Server 文档中记录,则它不属于 SQL Server 支持的部分。If a feature is not documented in Microsoft SQL Server documentation, it is not a supported part of SQL Server.