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: Converting Oracle Sequence to SQL Server "Denali"

    Updated 2/7/2012 Jiafei Yuan - Microsoft SQL Server Migration Assistant (SSMA) for Oracle v5.2. The information provided below is still valid for SSMA for Oracle v5.2, but SQL Server "Denali" is changed to 2012. Users should download the lastest SSMA for Oracle] One of the new feature in SQL Server...
  • Blog Post: Emulating Records and Collections via CLR UDT

            By Bill Ramos and Vishal Soni , Advaiya Inc. This blog covers how the SQL Server Migration Assistant (SSMA) for Oracle uses the SQL Server Common Language Runtime (CLR) User-Defined Types (UDT) for emulating Oracle Records and Collections.  In this blog...
  • 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 Materialized View to SQL Server

    By Gowri Shanker and Welly Lee. This blog post discusses approaches to migrate Oracle Materialized View to SQL Server. We compare Materialized View with SQL Server Indexed View, discuss scenarios supported by Indexed View and provide suggestions you can consider for the non-supported scenarios. ...
  • 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: Converting Oracle UDT to SQL Server TVP

    Oracle supports User Defined Type (UDT) which include object type and collection. This data type is not supported in SQL Server and SSMA does not support conversion of Oracle UDT. You may consider using SQL Server TVP when migrating your Oracle database to SQL Server. The following provides use scenarios...
  • 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: Migrating Oracle to SQL Server Using SSMA - Emulating Oracle Package Variables

    By Bill Ramos and Vishal Soni , Advaiya Inc. Oracle supports encapsulating variables, types, stored procedures, and functions into a package. When you convert Oracle packages, you need to convert: Procedures and functions - both public and private Variables Cursors Initialization...
  • Blog Post: Migrating Oracle to SQL Server using SSMA–Error O2SS0293: Columns list in set clause cannot be converted

    This blog post describes SSMA error message when converting Oracle PL/SQL UPDATE statement with column group assignment. Oracle PL/SQL allows you to perform multi column update through sub-query. Consider the following example: CREATE TABLE ACCOUNT ( ACCOUNT_ID NUMBER NOT NULL, ACCOUNT_OWNER VARCHAR2...
  • Blog Post: Saving Comments During Migration

    During migration to SQL Server, you may find that the source database schema contains some comments to describe the schema. This can be as a comment within programming code (such as Oracle PL/SQL) in procedure, function, package, view or as a comment that is part of the table/ column schema. SQL Server...
  • Blog Post: Video: Converting Schema to SQL Server

    This video walks you through the schema conversion of SSMA, including an example on how to resolve issue during conversion Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing Database Using SSMA Converting Schema to SQL...
  • Blog Post: A Foreign Affair

    You may run into issue when using SSMA to connect to Oracle database containing foreign characters (non-ASCII characters) in its schema. In the example below, we have an Oracle database containing a table with Japanese name: The issue is caused by the Oracle client provider not able to process...
  • Blog Post: A Curious Case of NUMBER truncation

    Oracle's FLOAT may truncate a float number beyond its binary digit limit. For example, execute the following in Oracle: DECLARE testvar FLOAT(5); BEGIN Testvar := 123.45; DBMS_OUTPUT.put_line(to_char(testvar)); END; The statement will return 120 as the number 123.45 is rounded...
  • 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...
Page 1 of 1 (18 items)