Release: SQL Server Migration Assistant (SSMA) v7.7

Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions). What is new? Each iteration of the…


Differentiating Microsoft’s Database Migration Tools and Services

Microsoft provides a suite of tools and services designed to assist users with migrating various types of source databases to a variety of target environments. A description of these tools and services is provided in the following sections. Azure Database Migration Service (Azure DMS) Azure DMS is an Azure-based service that is now available in Public…


Release: SQL Server Migration Assistant (SSMA) v7.6

Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions). What is new? Each iteration of the…


Release: SQL Server Migration Assistant (SSMA) v7.5

Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions). What is new? Each iteration of the…


Released: SQL Server Migration Assistant (SSMA) v7.4

Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions). What is new? SSMA for Oracle now…

0

Migration approach for Oracle features

This blog posting focuses on tasks associated with migrating an Oracle database to the latest version of SQL Server. If preparing for a migration requires changes to Oracle features/functionality, then it is important to carefully consider the potential impact of each change on the applications that use the database. This posting provides links to detail about workaround…

0

Extending SQL Server Migration Assistant’s conversion capabilities

With the SSMA 7.3 release, we exposed some of SSMA’s conversion functionality to the public in order to allow end-users to extend the conversion capabilities of the tool. I will try to cover some parts of it in a series of blog posts. Before we go into details on how to implement a custom conversion,…


Released: SQL Server Migration Assistant (SSMA) v7.3

Overview SQL Server Migration Assistant (SSMA)  for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2 and Access lets users convert database schema to Microsoft SQL Server schema, upload the schema, and migrate data to the target SQL Server (see below for supported versions). What is new? Improved quality and conversion metric with targeted fixes…


Access connectivity components for SSMA

We often receive questions about what is really needed to work with Access databases in SQL Server Migration Assistants (SSMA) for Access, so I thought I’ll do a quick run through what is actually required. The typical error message that you will get in SSMA, if required components are missing will look like this: “Retrieving…

8

SQL Server Migration Assistant: How to assess and migrate data from non Microsoft data platforms to SQL Server

Follow these step by step instructions to migrate schema and data from non Microsoft data platforms to SQL Server. This post illustrates the migration of an Oracle HR schema to SQL Server vNext CTP1 on Linux. Assess the source database and discover conversion rate and effort to resolve issues Click on the “File” menu and…

1