SQL Server Migration Assistant (SSMA) Team's Blog

How-to articles, tips-and-tricks, and guidelines for migrating from Oracle/Sybase/MySQL/Access to SQL Server and SQL Azure

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: "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 15 th 2012. Following are the products in SSMA v4.2 family of products for which this “End of Support” notice is applicable: SQL Server Migration...
  • Blog Post: 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...
  • Blog Post: Migrating a PHP Application using MySQL to SQL Server running PHP on IIS

    By Bill Ramos, Advaiya Inc. In this blog post, I’ll walk through an example of migrating a PHP application originally written for a Windows Apache MySQL PHP server ( WAMP ) onto an IIS server running PHP and SQL Server 2008 R2 Express (often referred to as WISP for Windows IIS SQL Server PHP...
  • Blog Post: How to: Migrate to a schema in an existing database using SSMA

    SSMA, by default, migrate to dbo schema in a SQL Server database with the same name as source database schema you are migrating from. If the database does not exists, then SSMA will prompt if you like to create a new database. You can modify the target migration to an existing database with the following...
  • Blog Post: Converting from MySQL to SQL Server: Working with Data Types

    By Bill Ramos, Advaiya Inc. [Updated 2/6/2012 Jiafei Yuan- Microsoft SQL Server Migration Assistant (SSMA) for MySQL v5.2. The information provided below is still valid for SSMA for MySQL v5.2. Users should download the lastest SSMA for MySQL] In this blog post, I’ll walk through the various...
  • Blog Post: Migrating from MySQL to SQL Azure Using SSMA

    [Updated 2/7/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. Users should download the lastest SSMA for MySQL] In this blog post, I will describe how to setup your trial SQL Azure account for your...
  • Blog Post: MySQL to SQL Server Migration: Method for Correcting Schema Issues

    [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. Users should download the lastest SSMA for MySQL] In the blog post MySQL to SQL Server Migration: How to Use SSMA , I showed the basic...
  • Blog Post: MySQL to SQL Server Migration: How to Use SSMA

    By Bill Ramos, Advaiya [Updated 2/6/2012 Han Wong - Microsoft SQL Server Migration Assistant (SSMA) for MySQL v5.2. The information provided below is still valid for SSMA for MySQL v5.2. Users should download the lastest SSMA for MySQL] In this blog, I’m going to walk you through the process...
  • Blog Post: Video: Resolving Migration Issue in MySQL

    This video covers common migration issues that a developer may encounter when they migrate from MySQL to SQL Server 2008. Check out other video in this series: Installing SSMA Assessing and Converting MySQL Schema Migrating Data
  • Blog Post: Video: Migrating MySQL Data

    This video covers the process of moving data from MySQL to SQL Server 2008 once the database structure has been migrated. Note: SSMA includes an option to do partial data migration. See this blog article on how to modify the sql statement to specify subset of data to be migrated...
  • Blog Post: Video: Converting MySQL Schema

    This video covers the steps involved when migrating database objects (Tables and Indices) from MySQL to SQL . Check out other video in this series: Installing SSMA Migrating Data Resolving Migration Issue
  • Blog Post: Video: Installing SSMA

    This video covers step-by-step instruction on how to install and get up and running with the SSMA tool for MySQL. Note: The video was recorded with SSMA CTP1 version. The full release version of the tool is now available and can be downloaded from here...
  • Blog Post: Accelerate migration to SQL Server with MAP Toolkit 5.5

    The next version of the Microsoft Assessment and Planning (MAP) Toolkit—version 5.5— is now available for free download. · Download MAP 5.5 Simplify planning for migration to the latest Microsoft products and technologies with the Microsoft Assessment and Planning (MAP) Toolkit...
  • Blog Post: "End of Support" for Older SSMA v4.0 family of Products

    [ Updated: 2/8/2012 Selina Jia] Microsoft would like to inform customers that support for SSMA v4.0 family of products (including SSMA Extension Packs) is going to end on October 30 th 2011. Following are the products in SSMA v4.0 family for which this “End of Support” notice is applicable...
  • Blog Post: How To Convert Individual Statement Using SSMA

    You can use SSMA to convert a statement (such as PL/SQL) into T-SQL statement using SSMA. This functionality can be used, for example, to convert embedded SQL statement inside an application that connects to the database. Use the following steps to convert individual statement: Open SSMA tool...
  • Blog Post: SQL Server Migration Videos

    Check out video from Joel Shalaby that include a demo on SSMA. SSMA Trailer with customer testimonials. Oracle - SQL Migation Case Study with AON and InfoSys.
Page 1 of 1 (23 items)