Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

This release of SQL Server Migration Assistant (SSMA) adds supports for SQL Server 2016. In this release, the following features have been added:

• Added conversion of DB2 in-memory tables and Columnstore indexes to leverage In-memory OLTP for SQL Server 2016 and In-Memory Columnstore for SQL Server 2016 and SQL Database
• Added conversion of DB2 access controls to SQL Server Policy objects (Row Level Security for DB2)
• Added conversion of DB2 system-versioned tables to SQL Server temporal tables
• Improved DB2 parser and resolver
• Removed installer check for .Net 2.0
• Removed unnecessary *.dll from Db2 installer
• Fixed "save project" and "open project" commands for SSMA Console
• Fixed "securepassword" command for SSMA Console
• Fixed counting of objects for initial loading
• Fixed bug in global settings
• Support for Azure 12

SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from DB2 to SQL Server and Azure SQL DB. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion and data migration.

This download includes a GUI client based application to manage migration process. The GUI client will install functionalities in SQL Server or Azure SQL DB to emulate DB2 features not natively supported in SQL server or Azure SQL DB.

SSMA 7.0 for DB2 is designed to support migration from DB2 on z/OS versions 9.0 and 10.0 and DB2 on Linux/Unix/Windows (LUW) versions 9.8 and 10.1 to SQL Server 2012, SQL Server 2014, SQL Server 2016 and Azure SQL DB.

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to December 2016.

No files found

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• Windows 7, Windows 8.1, Windows 10, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012R2

• Microsoft Windows Installer 3.1 or a later version.
• The Microsoft .NET Framework version 4.0 or a later version. You can obtain it from the .NET Framework Developer Center.
• The Microsoft OLEDB Provider for DB2 version 5. You can obtain the 32 bit and 64 bit versions of the provider as part of the Microsoft® SQL Server® 2014 Feature Pack here: http://www.microsoft.com/en-us/download/details.aspx?id=42295
• Access to and sufficient permissions on the computer that hosts the target instance of SQL Server.
• 4 GB RAM.

After the download, you must extract the installation files before you can install SSMA for DB2.

Installing the SSMA for DB2 Client

1. Double-click SSMA for Db2.7.0.exe.
2. On the 'Welcome' page, click Next.
3. If you do not have the prerequisites installed, a message will appear that indicates that you must first install required components. Make sure that you have installed all prerequisites, and then run the installation program again.
4. Read the End User License Agreement. If you agree to the terms, select "I accept the agreement" option and click Next.
5. On the 'Choose Setup Type' page, click Typical.
6. Click Install.