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

Overview Microsoft SQL Server Migration Assistant (SSMA) v7.3  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 in v7.3? Improved quality and conversion…

0

Latest Update – Microsoft SQL Server Migration Assistant (SSMA) v6.0 is now available.

SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of your database migration project.    The new version of  SSMA,…

24

Microsoft SQL Server Migration Assistant (SSMA) v5.3 is now available.

SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of your database migration project.  The new version of SSMA -…

19

Microsoft SQL Server Migration Assistant (SSMA) 5.2 is Now Available

Automating Database Migration to SQL Server 2012 SQL Server Migration Assistant (SSMA) v5.2 is now available. SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to…

65

SSMA Feature Overview

TechNet Magize published an article which provide overview of SQL Server Migration Assistant (SSMA) features and how it can be used to support database migration to SQL Server. SQL Server: Manage the Migration describes the main feature area of SSMA including migration assessment, converting database schema, migrating data, and testing database migration. If you prefer…

6

Announcing SQL Server Migration Assistant (SSMA) v.5.1

Automating database migration from Oracle, Sybase, MySQL, and Access database to SQL Azure and SQL Server “Denali”. Microsoft announced today the release of SQL Server Migration Assistant (SSMA) v.5.1, a family of products to automate database migration to all edition of SQL Server (including SQL Server Express) and SQL Azure. What’s New in this Release?…

15

Converting MySQL LIMIT to SQL Server "Denali"

[Updated 2/6/2012 Selina Jia – Microsoft SQL Server Migration Assistant (SSMA) for MySQL v5.2.  The information provided below is still valid for SSMA for MySQL v5.2, but SQL Server “Denali” is changed to 2012.  Users should download the lastest SSMA for MySQL] One of the new feature in SSMA for MySQL v.5.1 is the support for converting…

0

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

"End of Support" announcement for SQL Server Migration Assistant v4.2 family of products (support ends on July 15th, 2012)

Microsoft would like to inform customers that support for SSMA v4.2 family of products (including SSMA Extension Packs) is going to end on July 15th 2012. Following are the products in SSMA v4.2 family of products for which this “End of Support” notice is applicable: SQL Server Migration Assistant 2005 for Access v4.2 SQL Server…

0

Converting MySQL STR_TO_DATE function

MySQL provides STR_TO_DATE() standard function which convert string into date type. SSMA does not support conversion of STR_TO_DATE() function and when it encounters call to the function, SSMA generates a conversion error message “M2SS0201: MySQL standard function STR_TO_DATE is not supported in current SSMA version” You can use SQL Server’s CONVERT function to replace STR_TO_DATE….

2