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: Identifying Database Migration Opportunity Using MAP 6.0

    Microsoft announced the release of Microsoft Assessment and Planning (MAP) toolkit 6.0. The new version of MAP reports the existence of Oracle database instances and provides information that can be use to estimate total cost of ownership and return-on-investment (ROI) for migrating the Oracle schema...
  • 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: Migrating Oracle ANYDATA to SQL Server

    By Welly Lee, Pinaki Bag, and Jayakumar Tanneru. Oracle has an object data type called anydata . This data type supports wide range of data types. For example when creating a table with a column defined as anydata type, the column can store many types of data from string to numeric . SSMA does not...
  • Blog Post: Migrating Oracle to SQL Server using SSMA–Error O2SS0041 Illegal Identifier

    When converting Oracle schema to SQL Server using SSMA, you may encounter an error when your table contains a DATE column with default value. This blog post describes the reason for the error and what you should do when you encounter this error. Consider the following example -- Oracle source table:...
  • Blog Post: Improving Performance of SSMA Migration Assessment

    When performing migration assessment for a large schema (with thousands of objects), you can use the following to help improve performance: Run SSMA application on hardware with x64 bit Windows and memory of at least 4 GB. Force load the schema information prior performing migration assessment...
  • Blog Post: SSMA @TechEd Video

    SSMA session from North America TechEd is now available from Channel 9 .
  • Blog Post: Video: Automating Database Migration Using SSMA Console Application

    This video introduces SSMA console application which can automate your SSMA database migration tasks: Format: wmv Duration: 01:52 Detailed walkthough and sample file for using SSMA console application can be found here . Check out the other videos in this series: Introduction to...
  • Blog Post: Video: Analyzing Database Using SSMA

    This video walks you through database assessment feature of SSMA: Format: wmv Duration: 02:41 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...
  • Blog Post: 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...
  • Blog Post: 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 of...
  • Blog Post: 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...
  • Blog Post: Part1: Creating a Custom SSMA Report

    SSMA provides a migration assessment report to help you identify potential migration issues . You can generate the assessment report by selecting source schema, right click and select Create Report . Alternatively, you can also click on the Create Report button on the top navigation bar. The report...
Page 1 of 1 (15 items)