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

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.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…

15

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

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: 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

Database Experimentation Assistant – Command Line

#1 and #2 below are manual steps to capture and replay workloads. DEA command line support will be available in future releases. #3 for trace analysis is supported by DEA command line. Start a new workload capture Open <Dea_InstallPath>\Scripts\StartCaptureTrace.sql in SSMS Edit the following variables in the file @durationInMins  à time in minutes for workload…

1

How to use Database Experimentation Assistant tool

Capabilities The tool has three main features: Capture Trace: Ability to automatically capture a production workload trace with only a few inputs. Replay Trace: Ability to replay a trace on current and new/proposed instances of SQL. Workload Analysis Reports: Ability to generate new reports which provide insight into how workload performance changes across versions of…

0

Database Experimentation Assistant – Capture Trace

Capture trace allows you to easily produce a trace file (.trc) containing a log of what events occurred on the specified server within a given period of time. This action needs to be performed once per server. Note: Before starting your trace capture, please make sure to backup all your target databases. Query caching in…

1

Database Experimentation Assistant – Upcoming features

Here are the features that will be available for upcoming release. Stay tuned.. Automated script for capture and replay workload traces via command line options Support for the ability to capture multiple servers. Support validation checks to address ring fencing scenarios.

0