Preview release of SQL Server Migration Assistant (SSMA) for SQL Server 2016 RC0

Microsoft has released a preview release of SQL Server Migration Assistant (SSMA) that supports migrating databases from Oracle, Sybase ASE, DB2, MySQL and Access to SQL Server 2016 Release Candidate 0. In this release, the following features have been added: SSMA 6.1 Preview, all platforms: Support for SQL Server 2016 Release Candidate 0 Support for running…

4

Microsoft SQL Server Migration Assistant (SSMA) v6.0.1 is now available

Microsoft has released an update to SSMA 6.0 for Oracle, DB2, Sybase ASE, MySQL and Access. SSMA simplifies the database migration process by automating all aspects of migration including migration assessment analysis, schema conversion, SQL statement conversion and data migration. SSMA also includes migration testing to reduce the cost and risk of database migrations. Version 6.01 of SSMA includes the…

8

How SSMA Estimates Manual Conversion Time

SSMA automates conversion of most statement. There are a few features and syntax which SSMA is unable to migrate. In such situation, SSMA issues a migration error and for each error, SSMA provides estimated manual conversion time. I often asked how do we come up with the time. Those manual estimation time was calculated based…

0

Migrating from Sybase ASE to SQL Server – How to use SSMA for Sybase

[Updated 2/7/2012 Jiafei Yuan – Microsoft SQL Server Migration Assistant (SSMA) for Sybase v5.2.  The information provided below is still valid for SSMA for Sybase v5.2.  Users should download the lastest SSMA for Sybase]   In this blog, I’m going to walk you through the process of converting a derivation of the Sybase pubs2 (referred to as pubs in…

11

Migrating Sybase ASE to SQL Server: Similarities and Differences to Help in Planning a Migration Project

[Updated 2/7/2012 Jiafei Yuan – Microsoft SQL Server Migration Assistant (SSMA) for Sybase v5.2.  The information provided below is still valid for SSMA for Sybase v5.2.  Users should download the lastest SSMA for Sybase] This blog post explores the similarities and differences between Sybase Adaptive Server Enterprise (ASE) database applications and administration with Microsoft SQL Server to…

2

Video: Automating Database Migration Using SSMA Console Application

This video introduces SSMA console application which can automate your SSMA database migration tasks:   Detailed walkthough and sample file for using SSMA console application can be found here. Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing Database Using SSMA Converting Schema to SQL Server Migrating Data…

0

Video: Analyzing Database Using SSMA

This video walks you through database assessment feature of SSMA:   Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing Database Using SSMA Converting Schema to SQL Server Migrating Data Using SSMA Automating Database Migration Using SSMA Console Application

0

Protecting DBA’s secret

One common challenge for a migration project is for a DBA to give password to access a database that he/she owns. This article shows an approach where DBA can keep the password while allowing a separate migration team to run assessment and migration. This is done through SSMA console application which allows you to store…

0

Part3: Creating a Custom SSMA Report

In the last part of this installment, I will show an example of SSRS report using the data we parsed in part 2 and extracted from SSMA in part1. For this report, I would like to list all projects and its aggregate conversion rate, number of object, and number of errors. If there are multiple runs…

0

Part2: Creating a Custom SSMA Report

This is part 2 of the article for creating custom SSMA report using SSIS and SSRS. In the previous post, we discussed how to use SSIS package to extract XML files containing SSMA assessment report information into SQL Server table. This week, we will discuss how to parse the XML data. First, let’s create tables…

3