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…


Extending SQL Server Migration Assistant’s conversion capabilities

Extending SQL Server Migration Assistant’s conversion capabilities With 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…


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…

6

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

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

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? SQL vNext on Windows and Linux CTP1 is…

2