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…

0

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…

0

Released: Data Migration Assistant (DMA) v3.0

Overview Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It also allows you to not only move your schema, data, but also uncontained objects…

6

Released: Data Migration Assistant (DMA) v2.0

Overview Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It also allows you to not only move your schema, data, but also uncontained objects…

0

Technical Preview: Database Experimentation Assistant

Overview Database Experimentation Assistant (DEA) is a new Experimentation solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload. Customers who are upgrading from previous SQL server versions (starting 2005 and above) to any new version of the SQL server will be able to use these analysis…

20

Released: Data Migration Assistant (DMA) v1.0

Overview Data Migration Assistant (DMA) delivers scenarios that reduce the effort to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality after an upgrade. It recommends performance and reliability improvements for your target environment. DMA replaces SQL Server Upgrade Advisor. What is new? Discovery of issues that can affect…

6

Data Migration Assistant: FAQs

This page addresses all the frequently asked questions. 1. What is the difference between Upgrade Advisor (UA) and Data Migration Assistant (DMA)? All versions of UA are officially deprecated and have been replaced by DMA for your migration needs. The core differences between the tools are as follows: UA performs only assessments, DMA enable you…

0

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

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…

0

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…

0

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

Released: Data Migration Assistant (DMA) v2.1

Overview Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It also allows you to not only move your schema, data, but also uncontained objects…

5

Data Migration Assistant: How to run from command line

With DMA v2.1 and above when you install DMA, it will also install dmacmd.exe in %ProgramFiles%\Microsoft Data Migration Assistant\. Use dmacmd.exe to assess your databases in an unattended mode. This is especially useful when assessing several databases or huge databases. Output the result to JSON or CSV file.  Note Dmacmd.exe supports running assessments only. Migrations are not…

0